VIEW: APPS.JAI_RCV_TAX_V

Source

View Text - Preformatted

SELECT TRANSACTIONS.SHIPMENT_HEADER_ID , TRANSACTIONS.SHIPMENT_LINE_ID , TRANSACTIONS.TRANSACTION_ID , TRANSACTIONS.TRANSACTION_TYPE , TRANSACTIONS.QUANTITY , JRTL.TAX_LINE_NO , JRTL.TAX_NAME , JRTL.TAX_TYPE , JTC.TAX_ID, DECODE ( JRTL.TAX_RATE, NULL, DECODE( JRTL.QTY_RATE, NULL,'ADHOC','QUANTITY') , 'PERCENTAGE' ) RATE_TYPE , NVL(JRTL.TAX_RATE, QTY_RATE) TAX_RATE, JRTL.UOM, /* Bug 5093948. Added aliases */ JRTL.PRECEDENCE_1 , JRTL.PRECEDENCE_2 , JRTL.PRECEDENCE_3 , JRTL.PRECEDENCE_4 , JRTL.PRECEDENCE_5, /* Bug 5093948. Added precedences 6 to 10 */ JRTL.PRECEDENCE_6 , JRTL.PRECEDENCE_7 , JRTL.PRECEDENCE_8 , JRTL.PRECEDENCE_9 , JRTL.PRECEDENCE_10, JRTL.CURRENCY , JRTL.TAX_AMOUNT * TRANSACTIONS.FACTOR TAX_AMOUNT , JRTL.MODVAT_FLAG, JTC.MOD_CR_PERCENTAGE RECOVERABILITY , JRTL.TAX_MODIFIED_MANUALLY , JRTL.VENDOR_ID , JRTL.VENDOR_SITE_ID FROM ( SELECT SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID, TRANSACTION_ID, TRANSACTION_TYPE, QUANTITY, TAX_APPORTION_FACTOR FACTOR FROM JAI_RCV_TRANSACTIONS RT WHERE EXISTS ( SELECT '1' FROM JAI_RCV_LINE_TAXES WHERE SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID ) ) TRANSACTIONS, JAI_RCV_LINE_TAXES JRTL, JAI_CMN_TAXES_ALL JTC WHERE transactions.shipment_line_id = jrtl.shipment_line_id and jrtl.tax_id = jtc.tax_id

View Text - HTML Formatted

SELECT TRANSACTIONS.SHIPMENT_HEADER_ID
, TRANSACTIONS.SHIPMENT_LINE_ID
, TRANSACTIONS.TRANSACTION_ID
, TRANSACTIONS.TRANSACTION_TYPE
, TRANSACTIONS.QUANTITY
, JRTL.TAX_LINE_NO
, JRTL.TAX_NAME
, JRTL.TAX_TYPE
, JTC.TAX_ID
, DECODE ( JRTL.TAX_RATE
, NULL
, DECODE( JRTL.QTY_RATE
, NULL
, 'ADHOC'
, 'QUANTITY')
, 'PERCENTAGE' ) RATE_TYPE
, NVL(JRTL.TAX_RATE
, QTY_RATE) TAX_RATE
, JRTL.UOM
, /* BUG 5093948. ADDED ALIASES */ JRTL.PRECEDENCE_1
, JRTL.PRECEDENCE_2
, JRTL.PRECEDENCE_3
, JRTL.PRECEDENCE_4
, JRTL.PRECEDENCE_5
, /* BUG 5093948. ADDED PRECEDENCES 6 TO 10 */ JRTL.PRECEDENCE_6
, JRTL.PRECEDENCE_7
, JRTL.PRECEDENCE_8
, JRTL.PRECEDENCE_9
, JRTL.PRECEDENCE_10
, JRTL.CURRENCY
, JRTL.TAX_AMOUNT * TRANSACTIONS.FACTOR TAX_AMOUNT
, JRTL.MODVAT_FLAG
, JTC.MOD_CR_PERCENTAGE RECOVERABILITY
, JRTL.TAX_MODIFIED_MANUALLY
, JRTL.VENDOR_ID
, JRTL.VENDOR_SITE_ID
FROM ( SELECT SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, TRANSACTION_ID
, TRANSACTION_TYPE
, QUANTITY
, TAX_APPORTION_FACTOR FACTOR
FROM JAI_RCV_TRANSACTIONS RT
WHERE EXISTS ( SELECT '1'
FROM JAI_RCV_LINE_TAXES
WHERE SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID ) ) TRANSACTIONS
, JAI_RCV_LINE_TAXES JRTL
, JAI_CMN_TAXES_ALL JTC
WHERE TRANSACTIONS.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
AND JRTL.TAX_ID = JTC.TAX_ID