VIEW: APPS.AR_TAX_LINES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)