Product: | AR - Receivables |
---|---|
Description: | (Release 10SC Only) |
Implementation/DBA Data: | APPS.AR_TAX_LINES_V |
SELECT CTL_TAX.ROWID
, CTL_TAX.CUSTOMER_TRX_ID
, CTL_TAX.CUSTOMER_TRX_LINE_ID
, CTL_TAX.PREVIOUS_CUSTOMER_TRX_ID
, CTL_TAX.PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL_TAX.LINK_TO_CUST_TRX_LINE_ID
, CTL_LINE.LINE_NUMBER
, CTL_TAX.LINE_NUMBER
, CTL_TAX.TAX_PRECEDENCE
, VAT.TAX_CODE
, VAT.VAT_TAX_ID
, VAT.VALIDATE_FLAG
, CTL_TAX.TAX_RATE
, CTL_TAX.EXTENDED_AMOUNT
, CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG
, CTL_TAX.AUTOTAX
, CTL_TAX.INTERFACE_LINE_CONTEXT
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE1
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE2
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE3
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE4
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE5
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE6
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE7
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE8
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE9
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE10
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE11
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE12
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE13
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE14
, CTL_TAX.INTERFACE_LINE_ATTRIBUTE15
, CTL_TAX.DEFAULT_USSGL_TRANSACTION_CODE
, CTL_TAX.DEFAULT_USSGL_TRX_CODE_CONTEXT
, CTL_TAX.ATTRIBUTE_CATEGORY
, CTL_TAX.ATTRIBUTE1
, CTL_TAX.ATTRIBUTE2
, CTL_TAX.ATTRIBUTE3
, CTL_TAX.ATTRIBUTE4
, CTL_TAX.ATTRIBUTE5
, CTL_TAX.ATTRIBUTE6
, CTL_TAX.ATTRIBUTE7
, CTL_TAX.ATTRIBUTE8
, CTL_TAX.ATTRIBUTE9
, CTL_TAX.ATTRIBUTE10
, CTL_TAX.ATTRIBUTE11
, CTL_TAX.ATTRIBUTE12
, CTL_TAX.ATTRIBUTE13
, CTL_TAX.ATTRIBUTE14
, CTL_TAX.ATTRIBUTE15
, CTL_INV_LINE.LINE_NUMBER
, CTL_INV_TAX.LINE_NUMBER
, CTL_INV_TAX.TAX_PRECEDENCE
, INV_VAT.TAX_CODE
, CTL_INV_TAX.TAX_RATE
, CTL_INV_TAX.EXTENDED_AMOUNT
, CTL_INV_TAX.AMOUNT_INCLUDES_TAX_FLAG
, CTL_TAX.GLOBAL_ATTRIBUTE_CATEGORY
, CTL_TAX.GLOBAL_ATTRIBUTE1
, CTL_TAX.GLOBAL_ATTRIBUTE2
, CTL_TAX.GLOBAL_ATTRIBUTE3
, CTL_TAX.GLOBAL_ATTRIBUTE4
, CTL_TAX.GLOBAL_ATTRIBUTE5
, CTL_TAX.GLOBAL_ATTRIBUTE6
, CTL_TAX.GLOBAL_ATTRIBUTE7
, CTL_TAX.GLOBAL_ATTRIBUTE8
, CTL_TAX.GLOBAL_ATTRIBUTE9
, CTL_TAX.GLOBAL_ATTRIBUTE10
, CTL_TAX.GLOBAL_ATTRIBUTE11
, CTL_TAX.GLOBAL_ATTRIBUTE12
, CTL_TAX.GLOBAL_ATTRIBUTE13
, CTL_TAX.GLOBAL_ATTRIBUTE14
, CTL_TAX.GLOBAL_ATTRIBUTE15
, CTL_TAX.GLOBAL_ATTRIBUTE16
, CTL_TAX.GLOBAL_ATTRIBUTE17
, CTL_TAX.GLOBAL_ATTRIBUTE18
, CTL_TAX.GLOBAL_ATTRIBUTE19
, CTL_TAX.GLOBAL_ATTRIBUTE20
FROM RA_CUSTOMER_TRX_LINES CTL_INV_LINE
, RA_CUSTOMER_TRX_LINES CTL_INV_TAX
, AR_VAT_TAX INV_VAT
, RA_CUSTOMER_TRX_LINES CTL_LINE
, RA_CUSTOMER_TRX_LINES CTL_TAX
, AR_VAT_TAX VAT
WHERE CTL_TAX.LINK_TO_CUST_TRX_LINE_ID = CTL_LINE.CUSTOMER_TRX_LINE_ID
AND CTL_TAX.LINE_TYPE = 'TAX'
AND CTL_TAX.VAT_TAX_ID = VAT.VAT_TAX_ID(+)
AND CTL_TAX.PREVIOUS_CUSTOMER_TRX_LINE_ID = CTL_INV_TAX.CUSTOMER_TRX_LINE_ID (+)
AND CTL_INV_TAX.LINK_TO_CUST_TRX_LINE_ID = CTL_INV_LINE.CUSTOMER_TRX_LINE_ID (+)
AND CTL_INV_TAX.VAT_TAX_ID = INV_VAT.VAT_TAX_ID (+)