VIEW: APPS.JL_ZZ_AR_TX_EXC_CUS_V

Source

View Text - Preformatted

SELECT exc.rowid row_id, exc.exc_cus_id, exc.address_id, exc.tax_category_id, cat.tax_category, exc.end_date_active, exc.last_update_date, exc.last_updated_by, exc.tax_code, vat.tax_rate, vat.description, exc.base_rate, exc.start_date_active, exc.org_id, exc.last_update_login, exc.creation_date, exc.created_by, exc.attribute_category, exc.attribute1, exc.attribute2, exc.attribute3, exc.attribute4, exc.attribute5, exc.attribute6, exc.attribute7, exc.attribute8, exc.attribute9, exc.attribute10, exc.attribute11, exc.attribute12, exc.attribute13, exc.attribute14, exc.attribute15 FROM jl_zz_ar_tx_exc_cus exc, ar_vat_tax_all_b vat, jl_zz_ar_tx_categ_all cat, ar_system_parameters_all sys WHERE exc.tax_category_id = cat.tax_category_id AND cat.tax_rule_set = sys.global_attribute13 AND exc.tax_code = vat.tax_code AND NVL(vat.tax_type, 'VAT') = 'VAT' AND NVL(vat.tax_class, 'O') = 'O' AND NVL(vat.enabled_flag, 'Y') = 'Y' AND vat.set_of_books_id = sys.set_of_books_id AND exc.tax_category_id = DECODE(LTRIM(vat.global_attribute1, '0123456789 '), NULL, TO_NUMBER(vat.global_attribute1),NULL) AND exc.start_date_active <= NVL(vat.end_date, TO_DATE('4712/12/31', 'YYYY/MM/DD' )) AND exc.end_date_active >= vat.start_date AND NVL(exc.org_id,-99) = NVL(vat.org_id,-99) AND NVL(exc.org_id,-99) = NVL(cat.org_id,-99) AND NVL(exc.org_id,-99) = NVL(sys.org_id,-99) AND NOT EXISTS (SELECT 1 FROM ar_vat_tax vat1 WHERE vat1.tax_code = vat.tax_code AND vat1.set_of_books_id = vat.set_of_books_id AND NVL(vat1.tax_type, 'VAT') = 'VAT' AND NVL(vat1.tax_class, 'O') = 'O' AND NVL(vat1.enabled_flag, 'Y') = 'Y' AND vat1.global_attribute1 = vat.global_attribute1 AND vat1.start_date > vat.start_date AND vat1.start_date <= exc.end_date_active)

View Text - HTML Formatted

SELECT EXC.ROWID ROW_ID
, EXC.EXC_CUS_ID
, EXC.ADDRESS_ID
, EXC.TAX_CATEGORY_ID
, CAT.TAX_CATEGORY
, EXC.END_DATE_ACTIVE
, EXC.LAST_UPDATE_DATE
, EXC.LAST_UPDATED_BY
, EXC.TAX_CODE
, VAT.TAX_RATE
, VAT.DESCRIPTION
, EXC.BASE_RATE
, EXC.START_DATE_ACTIVE
, EXC.ORG_ID
, EXC.LAST_UPDATE_LOGIN
, EXC.CREATION_DATE
, EXC.CREATED_BY
, EXC.ATTRIBUTE_CATEGORY
, EXC.ATTRIBUTE1
, EXC.ATTRIBUTE2
, EXC.ATTRIBUTE3
, EXC.ATTRIBUTE4
, EXC.ATTRIBUTE5
, EXC.ATTRIBUTE6
, EXC.ATTRIBUTE7
, EXC.ATTRIBUTE8
, EXC.ATTRIBUTE9
, EXC.ATTRIBUTE10
, EXC.ATTRIBUTE11
, EXC.ATTRIBUTE12
, EXC.ATTRIBUTE13
, EXC.ATTRIBUTE14
, EXC.ATTRIBUTE15
FROM JL_ZZ_AR_TX_EXC_CUS EXC
, AR_VAT_TAX_ALL_B VAT
, JL_ZZ_AR_TX_CATEG_ALL CAT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE EXC.TAX_CATEGORY_ID = CAT.TAX_CATEGORY_ID
AND CAT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND EXC.TAX_CODE = VAT.TAX_CODE
AND NVL(VAT.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(VAT.TAX_CLASS
, 'O') = 'O'
AND NVL(VAT.ENABLED_FLAG
, 'Y') = 'Y'
AND VAT.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID
AND EXC.TAX_CATEGORY_ID = DECODE(LTRIM(VAT.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(VAT.GLOBAL_ATTRIBUTE1)
, NULL)
AND EXC.START_DATE_ACTIVE <= NVL(VAT.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD' ))
AND EXC.END_DATE_ACTIVE >= VAT.START_DATE
AND NVL(EXC.ORG_ID
, -99) = NVL(VAT.ORG_ID
, -99)
AND NVL(EXC.ORG_ID
, -99) = NVL(CAT.ORG_ID
, -99)
AND NVL(EXC.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND NOT EXISTS (SELECT 1
FROM AR_VAT_TAX VAT1
WHERE VAT1.TAX_CODE = VAT.TAX_CODE
AND VAT1.SET_OF_BOOKS_ID = VAT.SET_OF_BOOKS_ID
AND NVL(VAT1.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(VAT1.TAX_CLASS
, 'O') = 'O'
AND NVL(VAT1.ENABLED_FLAG
, 'Y') = 'Y'
AND VAT1.GLOBAL_ATTRIBUTE1 = VAT.GLOBAL_ATTRIBUTE1
AND VAT1.START_DATE > VAT.START_DATE
AND VAT1.START_DATE <= EXC.END_DATE_ACTIVE)