VIEW: APPS.AR_TAX_SUMM_V

Source

View Text - Preformatted

SELECT CTL_TAX.TAX_PRECEDENCE , VAT.TAX_CODE , CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG , CTL_TAX.TAX_RATE , CTL_TAX.CUSTOMER_TRX_ID , SUM(CTL_TAX.EXTENDED_AMOUNT) 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 (+) GROUP BY CTL_TAX.TAX_PRECEDENCE, VAT.TAX_CODE, CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG, CTL_TAX.TAX_RATE, CTL_TAX.CUSTOMER_TRX_ID

View Text - HTML Formatted

SELECT CTL_TAX.TAX_PRECEDENCE
, VAT.TAX_CODE
, CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG
, CTL_TAX.TAX_RATE
, CTL_TAX.CUSTOMER_TRX_ID
, SUM(CTL_TAX.EXTENDED_AMOUNT)
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 (+) GROUP BY CTL_TAX.TAX_PRECEDENCE
, VAT.TAX_CODE
, CTL_TAX.AMOUNT_INCLUDES_TAX_FLAG
, CTL_TAX.TAX_RATE
, CTL_TAX.CUSTOMER_TRX_ID