View: AR_AP_TAX_CODES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_AP_TAX_CODES_V

View Text

SELECT DISTINCT NVL(VAT.ORG_ID
, -1) ORG_ID
, VAT.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, VAT.VAT_TAX_ID TAX_CODE_ID
, VAT.TAX_TYPE TAX_TYPE
, VAT.VAT_TRANSACTION_TYPE VAT_TRANSACTION_TYPE
, VAT.TAX_CLASS TAX_CLASS
, VAT.TAX_CODE TAX_CODE
, VAT.TAX_RATE TAX_RATE
, VAT.DESCRIPTION DESCRIPTION
, 'AR' PRODUCT
, VAT.START_DATE START_DATE
, VAT.END_DATE END_DATE
, VAT.PRINTED_TAX_NAME PRINTED_TAX_NAME
FROM AR_VAT_TAX_ALL_VL VAT
WHERE VAT.TAX_ACCOUNT_ID IS NOT NULL UNION ALL SELECT DISTINCT NVL(TC.ORG_ID
, -1) ORG_ID
, TC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TC.TAX_ID TAX_CODE_ID
, TC.TAX_TYPE TAX_TYPE
, TC.VAT_TRANSACTION_TYPE VAT_TRANSACTION_TYPE
, 'I' TAX_CLASS
, TC.NAME TAX_CODE
, TC.TAX_RATE TAX_RATE
, TC.DESCRIPTION DESCRIPTION
, 'AP' PRODUCT
, TO_DATE(NULL) START_DATE
, TC.INACTIVE_DATE END_DATE
, TC.NAME PRINTED_TAX_NAME
FROM AP_TAX_CODES_ALL TC
WHERE TC.TAX_TYPE NOT IN ('OFFSET'
, 'AWT')
AND TC.TAX_CODE_COMBINATION_ID IS NOT NULL

Columns