[Home] [Help]
View: 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
Name |
ORG_ID |
SET_OF_BOOKS_ID |
TAX_CODE_ID |
TAX_TYPE |
VAT_TRANSACTION_TYPE |
TAX_CLASS |
TAX_CODE |
TAX_RATE |
DESCRIPTION |
PRODUCT |
START_DATE |
END_DATE |
PRINTED_TAX_NAME |