Attachment 1969 Details for Bug 6548 – SS_0900_IMIS_Against call id - 6548_A

SS_0900_IMIS_Against call id - 6548_A

SS_0900_IMIS_Against call id - 6548_A.sql (text/x-vhdl), 1.22 KB, created by Sharad on 2021-06-17 17:06:41 IST

(hide)

Description:

Filename:

MIME Type:

Creator: Sharad

Created: 2021-06-17 17:06:41 IST

Size: 1.22 KB

patch

obsolete

>-- PKG_AP.DR_SUPP_ON_REJ_AND_SS    
>
>-- revert
>
>-- Line No.:- 10939
>
>                -- Bgn --
>                -- Against call id - 6548  
>                -- By ss on dt. 16/06/2021
>                -- Comment old condition 
>                /* 
>
>-- Line No.:- 10944
>
>                */
>                -- End --
>
>
>
>
>
>	UPDATE WAREHOUSE_TRANSACTIONS SET STATUS = 'Z' 
>	WHERE COMPANY 			= 	'01'
>	AND TRANSACTION_TYPE 	=	'W8'
>	AND TRANSACTION_SERIES	=	'2106'
>	AND TRANSACTION_NO		=	1
>	AND ENTRY_NO			= 	742;
>
>/*
>	-- Script for checking purpose -- 
>	
>	SELECT * FROM WAREHOUSE_TRANSACTIONS
>	WHERE COMPANY 			= 	'01'
>	AND TRANSACTION_TYPE 	=	'W8'
>	AND TRANSACTION_SERIES	=	'2106'
>	AND TRANSACTION_NO		=	1
>	AND ENTRY_NO			= 	742;
>
>	SELECT * FROM WAREHOUSE_TRANSFER_ITEMS
>	WHERE COMPANY 			= 	'01'
>	AND TRANSACTION_TYPE 	=	'W8'
>	AND TRANSACTION_SERIES	=	'2106'
>	AND ENTRY_NO 			= 	742;
>	
>	SELECT * FROM WAREHOUSE_TRANSACTION_ITEMS
>	WHERE COMPANY 			= 	'01'
>	AND TRANSACTION_TYPE 	=	'W8'
>	AND TRANSACTION_SERIES	=	'2106'
>	AND ENTRY_NO 			= 	742;
>	
>	SELECT * FROM  JOURNAL_VOUCHERS
>	WHERE REF_COMPANY 		= '01'
>	AND REF_VOUCHER_TYPE 	= 'W8'
>	AND REF_VOUCHER_SERIES 	= '2106
>	AND REF_VOUCHER_NUMBER 	= 1;
>
>
>*/

Actions: View

Attachments on bug 6548: 1955 | 1963 | 1969