View: ECE_CDMO_LINE_TAX_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts line tax informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Line Tax View@rep:category BUSINESS_ENTITY AR
Implementation/DBA Data:	APPS.ECE_CDMO_LINE_TAX_V

View Text

SELECT RCT.CUSTOMER_TRX_ID TRANSACTION_ID
, RCTL1.LINE_NUMBER LINE_NUMBER
, RCTL2.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, RCTL2.LINE_NUMBER TAX_LINE_NUMBER
, RCTL2.LINE_TYPE LINE_TYPE
, RCTL2.EXTENDED_AMOUNT TAX_AMOUNT
, RCTL2.TAX_RATE TAX_RATE
, RCTL2.TAX_PRECEDENCE TAX_PRECEDENCE
, AVT.TAX_CODE TAX_CODE
, RCTL2.LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID
, RCTL2.ATTRIBUTE_CATEGORY TAX_ATTRIBUTE_CATEGORY
, RCTL2.ATTRIBUTE1 TAX_ATTRIBUTE1
, RCTL2.ATTRIBUTE2 TAX_ATTRIBUTE2
, RCTL2.ATTRIBUTE3 TAX_ATTRIBUTE3
, RCTL2.ATTRIBUTE4 TAX_ATTRIBUTE4
, RCTL2.ATTRIBUTE5 TAX_ATTRIBUTE5
, RCTL2.ATTRIBUTE6 TAX_ATTRIBUTE6
, RCTL2.ATTRIBUTE7 TAX_ATTRIBUTE7
, RCTL2.ATTRIBUTE8 TAX_ATTRIBUTE8
, RCTL2.ATTRIBUTE9 TAX_ATTRIBUTE9
, RCTL2.ATTRIBUTE10 TAX_ATTRIBUTE10
, RCTL2.ATTRIBUTE11 TAX_ATTRIBUTE11
, RCTL2.ATTRIBUTE12 TAX_ATTRIBUTE12
, RCTL2.ATTRIBUTE13 TAX_ATTRIBUTE13
, RCTL2.ATTRIBUTE14 TAX_ATTRIBUTE14
, RCTL2.ATTRIBUTE15 TAX_ATTRIBUTE15
, RCTL2.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, RCTL2.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, RCTL2.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, AVT.TAX_TYPE TAX_TYPE
, AVT.DESCRIPTION DESCRIPTION
, NULL LOCATION
, NULL TAX_CLASSIFICATION
, AVT.VAT_TRANSACTION_TYPE VAT_TRANSACTION_TYPE
, AVT.ATTRIBUTE_CATEGORY VAT_TAX_ATTRIBUTE_CATEGORY
, AVT.ATTRIBUTE1 VAT_TAX_ATTRIBUTE1
, AVT.ATTRIBUTE2 VAT_TAX_ATTRIBUTE2
, AVT.ATTRIBUTE3 VAT_TAX_ATTRIBUTE3
, AVT.ATTRIBUTE4 VAT_TAX_ATTRIBUTE4
, AVT.ATTRIBUTE5 VAT_TAX_ATTRIBUTE5
, AVT.ATTRIBUTE6 VAT_TAX_ATTRIBUTE6
, AVT.ATTRIBUTE7 VAT_TAX_ATTRIBUTE7
, AVT.ATTRIBUTE8 VAT_TAX_ATTRIBUTE8
, AVT.ATTRIBUTE9 VAT_TAX_ATTRIBUTE9
, AVT.ATTRIBUTE10 VAT_TAX_ATTRIBUTE10
, AVT.ATTRIBUTE11 VAT_TAX_ATTRIBUTE11
, AVT.ATTRIBUTE12 VAT_TAX_ATTRIBUTE12
, AVT.ATTRIBUTE13 VAT_TAX_ATTRIBUTE13
, AVT.ATTRIBUTE14 VAT_TAX_ATTRIBUTE14
, AVT.ATTRIBUTE15 VAT_TAX_ATTRIBUTE15
FROM RA_CUSTOMER_TRX_LINES RCTL1
, RA_CUSTOMER_TRX RCT
, RA_CUSTOMER_TRX_LINES RCTL2
, AR_VAT_TAX AVT
WHERE RCTL1.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID AND RCTL1.CUSTOMER_TRX_LINE_ID = RCTL2.LINK_TO_CUST_TRX_LINE_ID
AND RCTL2.VAT_TAX_ID = AVT.VAT_TAX_ID (+) AND RCTL1.LINE_TYPE != 'TAX'
AND RCTL2.LINE_TYPE IN ('CHARGE'
, 'FREIGHT'
, 'TAX')

Columns