Form no :armf5325
Forn name : TCS Master
Module : Account receivable

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;