View: JAI_RCV_TAX_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RCV_TAX_V

View Text

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

Columns