| Summary: | CREATE MASTER FROM | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS AR | Reporter: | Mahender <mahender.singh> |
| Component: | IMIS AR FORMS AND REPORTS | Assignee: | Shakun <shakun.sharma> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Database: | Module ID: | ||
|
Comment 3
Shakun
2020-09-08 14:33:42 IST
FUNCTION GET_CUSTOMER_SALES
(P_COMPANY_CODE VARCHAR2
,P_CUSTOMER_CODE VARCHAR2
,P_DATE VARCHAR2
)
RETURN NUMBER
IS
--CREATED BY MS DT. 05/09/2020
--BUGZILLA CALL ID 4372
V_SALE_AMOUNT NUMBER :=0;
BEGIN
BEGIN
SELECT SUM(NVL(VOUCHER_AMOUNT,0)) INTO V_SALE_AMOUNT
FROM VW_CUSTOMER_LEDGER C, VW_FISCAL_YEARS F
WHERE C.VOUCHER_TYPE IN ('SI','I1','G5','LI')
AND C.VOUCHER_DATE BETWEEN F.YEAR_BGN_DATE AND F.YEAR_END_DATE
AND F.COMPANY_CODE = C.COMPANY
AND P_DATE BETWEEN F.YEAR_BGN_DATE AND F.YEAR_END_DATE
AND C.COMPANY = P_COMPANY_CODE
AND C.CUSTOMER_CODE = P_CUSTOMER_CODE;
EXCEPTION
WHEN NO_DATA_FOUND THEN NULL;
WHEN TOO_MANY_ROWS THEN NULL;
END;
RETURN(NVL(V_SALE_AMOUNT,0));
END;
CREATE TABLE TCS_ON_SALES (TCS_CODE VARCHAR2(10) ,DESCRIPTION VARCHAR2(100) ,FROM_DATE DATE ,PAN_REQUIRED VARCHAR2(1) ,TCS_RATE NUMBER(9,2) ,STATUS VARCHAR2(1) ,CREATED_BY VARCHAR2(10) ,CREATED_ON DATE ,LAST_UPD_BY VARCHAR2(10) ,LAST_UPD_ON DATE ) |