View: ARBV_TAXES

Product:	AR - Receivables
Description:	This shows detailed tax information associated with transaction line items.
Implementation/DBA Data:	APPS.ARBV_TAXES

View Text

SELECT /* UNIQUE ATTRIBUTES */ CTL.CUSTOMER_TRX_LINE_ID
, /* REGULAR ATTRIBUTES */ CTL.EXTENDED_AMOUNT
, '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING'
, CTL.TAX_RATE
, CTL.TAX_EXEMPT_NUMBER
, '_LA:CTL.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING'
, '_LA:CTL.AMOUNT_INCLUDES_TAX_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ CTL.CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL.INITIAL_CUSTOMER_TRX_LINE_ID
, CTL.LINK_TO_CUST_TRX_LINE_ID
, CTL.ORG_ID
, /* WHO COLUMNS */ CTL.LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY
, CTL.CREATION_DATE
, CTL.CREATED_BY
FROM RA_CUSTOMER_TRX_LINES_ALL CTL
WHERE CTL.LINE_TYPE = 'TAX'

Columns