Attachment 1975 Details for Bug 6549 – SS_0901_IMIS_Against call id - 6549

SS_0901_IMIS_Against call id - 6549

SS_0901_IMIS_Against call id - 6549.sql (text/x-vhdl), 1.02 KB, created by Sharad on 2021-06-21 11:52:25 IST

(hide)

Description:

Filename:

MIME Type:

Creator: Sharad

Created: 2021-06-21 11:52:25 IST

Size: 1.02 KB

patch

obsolete

>-- STORE_TRANSACTION_ITEMS_TRG
>
>-- Line No.:- 99 
>
>				-- Bgn -- 
>				-- Against call id - 6549
>				-- By ss on dt. 17/06/2021
>				o.REF_TRANSACTION_TYPE 		:= :o.REF_TRANSACTION_TYPE;
>				n.REF_TRANSACTION_TYPE 		:= :n.REF_TRANSACTION_TYPE;
>				o.REF_TRANSACTION_SERIES 	:= :o.REF_TRANSACTION_SERIES;
>				n.REF_TRANSACTION_SERIES 	:= :n.REF_TRANSACTION_SERIES;
>				o.REF_TRANSACTION_NO 		:= :o.REF_TRANSACTION_NO;
>				n.REF_TRANSACTION_NO 		:= :n.REF_TRANSACTION_NO;
>				o.REF_TRANSACTION_DATE 		:= :o.REF_TRANSACTION_DATE;
>				n.REF_TRANSACTION_DATE 		:= :n.REF_TRANSACTION_DATE;
>				
>				
>				IF NVL(:n.REF_TRANSACTION_TYPE, 0) = 'DC' AND :n.STATUS IN ('A', 'Y') THEN 
>				
>					UPDATE DELIVERY_CHALLAN_DETAIL SET RECEIVED_QUANTITY = NVL(RECEIVED_QUANTITY,0) + NVL(:n.TRANSACTION_ITEM_QTY,0)  
>					WHERE COMPANY 		=	:n.COMPANY
>					AND CHALLAN_TYPE 	= 	:n.REF_TRANSACTION_TYPE
>					AND CHALLAN_SERIES 	= 	:n.REF_TRANSACTION_SERIES
>					AND CHALLAN_NO 		= 	:n.REF_TRANSACTION_NO;
>					
>				END IF;				
>				-- End --

Actions: View

Attachments on bug 6549: 1956 | 1975