Attachment 1888 Details for Bug 6219 – SS_0876_IMIS_Against call id - 6219

SS_0876_IMIS_Against call id - 6219

SS_0876_IMIS_Against call id - 6219.sql (text/x-vhdl), 3.25 KB, created by Sharad on 2021-04-29 14:57:18 IST

(hide)

Description:

Filename:

MIME Type:

Creator: Sharad

Created: 2021-04-29 14:57:18 IST

Size: 3.25 KB

patch

obsolete

>-- PKG_AR.TPC_MISCELLANEOUS_VOUCHERS
>
>-- Line no.- 10893
>
>-- Bgn --
>-- Against call id - 6219
>-- By ss on dt. 26/04/2021
>V_TEAM_CODE			VARCHAR2(6);
>-- End --
>
>
>-- Line no.- 10949
>
>        -- Bgn --
>		-- Against call id - 6219
>		-- By ss on dt. 26/04/2021
>		-- Expense Voucher mail should send to FMCG ASM directly instead of ZSM.
>		-- I want to do these changes in FMCG Division only not in TR. 
>		BEGIN
>			SELECT DISTINCT TEAM_CODE
>			INTO V_TEAM_CODE
>			FROM SALES_WARD_CUSTOMERS SWC, SALES_ZONES SZ
>			WHERE SWC.ENTERPRISE_ID = 	SZ.ENTERPRISE_ID
>			AND  SWC.ZONE_CODE 		= 	SZ.ZONE_CODE 
>			AND  SWC.CUSTOMER_CODE	=	n.ACCOUNT_CODE;
>        EXCEPTION
>            WHEN NO_DATA_FOUND THEN 
>            	RAISE_APPLICATION_ERROR(-20001, 'Please define customer code in "Sales Ward Customers".');
>      			RETURN;
>            WHEN TOO_MANY_ROWS THEN NULL;
>        END; 
>        
>		IF V_TEAM_CODE 	=	'002' THEN    
>		
>	        BEGIN
>				SELECT EMAIL_ID
>				INTO V_SALEMAN_EMAIL_ID
>				FROM ALL_SALESMEN
>				WHERE SALESMAN_CODE =(
>										SELECT AREA_HEAD
>										FROM SALES_AREA_HEADS A
>				      					WHERE BGN_DATE = (
>				      										SELECT MAX(BGN_DATE) 
>				      										FROM SALES_AREA_HEADS B
>				           									WHERE B.STATUS 	= A.STATUS
>				           									AND A.ZONE_CODE = B.ZONE_CODE
>				           									AND A.AREA_CODE = B.AREA_CODE
>				                    					 )
>				                    	AND A.AREA_CODE	= (
>				                    						SELECT AREA_CODE FROM SALES_WARD_CUSTOMERS A
>				                                            WHERE CUSTOMER_CODE = n.ACCOUNT_CODE
>				                                            AND n.VOUCHER_DATE BETWEEN BGN_DATE AND NVL(END_DATE,n.VOUCHER_DATE)
>				                                            AND A.SALES_WARD_CUSTOMERS_RECID = (
>				                                            										SELECT MAX(SALES_WARD_CUSTOMERS_RECID)
>				                                            										FROM SALES_WARD_CUSTOMERS A
>				                                                      								WHERE CUSTOMER_CODE = n.ACCOUNT_CODE
>				                                                       								AND n.VOUCHER_DATE BETWEEN BGN_DATE AND NVL(END_DATE,n.VOUCHER_DATE)
>				                                                       								AND A.BGN_DATE = (
>				                                                       													SELECT MAX(BGN_DATE)
>				                                                       													FROM SALES_WARD_CUSTOMERS B
>				         																								WHERE CUSTOMER_CODE = n.ACCOUNT_CODE
>				         																								AND   n.VOUCHER_DATE BETWEEN BGN_DATE AND NVL(END_DATE,n.VOUCHER_DATE )
>				         																							 )
>				                                 												)
>				                                 		)
>				                     	AND A.STATUS = 'A'
>				                      )
>				AND EMAIL_ID IS NOT NULL;
>	        EXCEPTION
>	            WHEN NO_DATA_FOUND THEN NULL;
>	            WHEN TOO_MANY_ROWS THEN RAISE_APPLICATION_ERROR(-20001, 'Customer zone data not correct ' ||n.ACCOUNT_CODE);
>	        END;				
>		ELSE
>		-- End --		
>
>-- Line No.- 11035
>
>       	-- Bgn --
>		-- Against call id - 6219
>        END IF;
>        -- End --

Actions: View

Attachments on bug 6219: 1828 | 1888