Attachment 1858 Details for Bug 6323 – SS_0864_IPOS_Against call id - 6323

SS_0864_IPOS_Against call id - 6323

SS_0864_IPOS_Against call id - 6323.sql (text/plain), 1.85 KB, created by Sharad on 2021-04-14 18:18:53 IST

(hide)

Description:

Filename:

MIME Type:

Creator: Sharad

Created: 2021-04-14 18:18:53 IST

Size: 1.85 KB

patch

obsolete

>UPDATE INVOICE_ITEMS SET  COMMODITY_CODE = 'B5519', EXCISE_TARIFF = '420239'
>WHERE COMPANY			=	'R2'
>AND INVOICE_TYPE 		=	'I1'
>AND INVOICE_SERIES 		= 	'TI21'
>AND ENTRY_NO			=	6513
>AND INVOICE_NO			=	2
>AND EXCISE_TARIFF 		IN ( '4202');
>
>UPDATE INVOICE_ITEMS SET COMMODITY_CODE = 'B7068', EXCISE_TARIFF = '48205000'
>WHERE COMPANY			=	'R2'
>AND INVOICE_TYPE 		=	'I1'
>AND INVOICE_SERIES 		= 	'TI21'
>AND ENTRY_NO			=	6513
>AND INVOICE_NO			=	2
>AND EXCISE_TARIFF 		IN ( '%4820%');
>
>UPDATE TRANSIT_XFR_ITEMS SET COMMODITY_CODE = 'B7068', EXCISE_TARIFF = '48205000'
>WHERE COMPANY_CODE			=	'R3'
>AND DOCUMENT_TYPE 			=	'I1'
>AND DOCUMENT_SERIES 		= 	'TI21'
>AND ENTRY_NUMBER			=	6513
>AND DOCUMENT_NUMBER			=	2
>AND EXCISE_TARIFF 			IN ( '%4820%');
>
>UPDATE TRANSIT_XFR_ITEMS SET COMMODITY_CODE = 'B5519', EXCISE_TARIFF = '420239'
>WHERE COMPANY_CODE			=	'R3'
>AND DOCUMENT_TYPE 			=	'I1'
>AND DOCUMENT_SERIES 		= 	'TI21'
>AND ENTRY_NUMBER			=	6513
>AND DOCUMENT_NUMBER			=	2
>AND EXCISE_TARIFF 			IN ( '4202');
>
>/*
>-- Script for Checking Purpose --
>
>SELECT * FROM INVOICE_ITEMS
>WHERE COMPANY			=	'R2'
>AND INVOICE_TYPE 		=	'I1'
>AND INVOICE_SERIES 		= 	'TI21'
>AND ENTRY_NO			=	6513
>AND INVOICE_NO			=	2
>AND EXCISE_TARIFF 		IN ( '4202');
>
>SELECT * FROM INVOICE_ITEMS
>WHERE COMPANY			=	'R2'
>AND INVOICE_TYPE 		=	'I1'
>AND INVOICE_SERIES 		= 	'TI21'
>AND ENTRY_NO			=	6513
>AND INVOICE_NO			=	2
>AND EXCISE_TARIFF 		IN ( '%4820%');
>
>SELECT * FROM TRANSIT_XFR_ITEMS
>WHERE COMPANY_CODE			=	'R3'
>AND DOCUMENT_TYPE 			=	'I1'
>AND DOCUMENT_SERIES 		= 	'TI21'
>AND ENTRY_NUMBER			=	6513
>AND DOCUMENT_NUMBER			=	2
>AND EXCISE_TARIFF 			IN ( '%4820%');
>
>SELECT * FROM TRANSIT_XFR_ITEMS
>WHERE COMPANY_CODE			=	'R3'
>AND DOCUMENT_TYPE 			=	'I1'
>AND DOCUMENT_SERIES 		= 	'TI21'
>AND ENTRY_NUMBER			=	6513
>AND DOCUMENT_NUMBER			=	2
>AND EXCISE_TARIFF 			IN ( '4202');
>
>*/

Actions: View

Attachments on bug 6323: 1858 | 1860 | 1861