VIEW: APPS.AR_AP_TAX_CODES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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