VIEW: APPS.JL_ZZ_AR_TX_SCHEDULES_V

Source

View Text - Preformatted

SELECT sch.rowid row_id , sch.tax_categ_slab_id , sch.tax_category_id , sch.end_date_active , sch.min_taxable_basis , sch.last_update_date , sch.last_updated_by , sch.max_taxable_basis , art.tax_code , art.description , art.tax_rate , sch.start_date_active , sch.org_id, sch.last_update_login , sch.creation_date , sch.created_by , sch.attribute_category , sch.attribute1 , sch.attribute2 , sch.attribute3 , sch.attribute4 , sch.attribute5 , sch.attribute6 , sch.attribute7 , sch.attribute8 , sch.attribute9 , sch.attribute10 , sch.attribute11 , sch.attribute12 , sch.attribute13 , sch.attribute14 , sch.attribute15 FROM jl_zz_ar_tx_schedules sch , ar_vat_tax_all_b art , ar_system_parameters_all sys WHERE sch.tax_code is not null AND art.tax_code = sch.tax_code AND sch.tax_category_id = decode(ltrim(art.global_attribute1, '0123456789 '), null, to_number(art.global_attribute1), null) AND sch.start_date_active <= NVL(art.end_date, to_date('4712/12/31', 'YYYY/MM/DD')) AND sch.end_date_active >= art.start_date AND NVL(art.tax_class, 'O') = 'O' AND NVL(art.enabled_flag, 'Y') = 'Y' AND art.set_of_books_id = sys.set_of_books_id AND NVL(sch.org_id,-99) = NVL(art.org_id,-99) AND NVL(sch.org_id,-99) = NVL(sys.org_id,-99) UNION SELECT sch.rowid row_id , sch.tax_categ_slab_id , sch.tax_category_id , sch.end_date_active , sch.min_taxable_basis , sch.last_update_date , sch.last_updated_by , sch.max_taxable_basis , to_char(null) tax_code , to_char(null) description , to_number(null) tax_rate , sch.start_date_active , sch.org_id, sch.last_update_login , sch.creation_date , sch.created_by , sch.attribute_category , sch.attribute1 , sch.attribute2 , sch.attribute3 , sch.attribute4 , sch.attribute5 , sch.attribute6 , sch.attribute7 , sch.attribute8 , sch.attribute9 , sch.attribute10 , sch.attribute11 , sch.attribute12, sch.attribute13 , sch.attribute14 , sch.attribute15 FROM jl_zz_ar_tx_schedules sch WHERE sch.tax_code IS NULL

View Text - HTML Formatted

SELECT SCH.ROWID ROW_ID
, SCH.TAX_CATEG_SLAB_ID
, SCH.TAX_CATEGORY_ID
, SCH.END_DATE_ACTIVE
, SCH.MIN_TAXABLE_BASIS
, SCH.LAST_UPDATE_DATE
, SCH.LAST_UPDATED_BY
, SCH.MAX_TAXABLE_BASIS
, ART.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, SCH.START_DATE_ACTIVE
, SCH.ORG_ID
, SCH.LAST_UPDATE_LOGIN
, SCH.CREATION_DATE
, SCH.CREATED_BY
, SCH.ATTRIBUTE_CATEGORY
, SCH.ATTRIBUTE1
, SCH.ATTRIBUTE2
, SCH.ATTRIBUTE3
, SCH.ATTRIBUTE4
, SCH.ATTRIBUTE5
, SCH.ATTRIBUTE6
, SCH.ATTRIBUTE7
, SCH.ATTRIBUTE8
, SCH.ATTRIBUTE9
, SCH.ATTRIBUTE10
, SCH.ATTRIBUTE11
, SCH.ATTRIBUTE12
, SCH.ATTRIBUTE13
, SCH.ATTRIBUTE14
, SCH.ATTRIBUTE15
FROM JL_ZZ_AR_TX_SCHEDULES SCH
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE SCH.TAX_CODE IS NOT NULL
AND ART.TAX_CODE = SCH.TAX_CODE
AND SCH.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND SCH.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND SCH.END_DATE_ACTIVE >= ART.START_DATE
AND NVL(ART.TAX_CLASS
, 'O') = 'O'
AND NVL(ART.ENABLED_FLAG
, 'Y') = 'Y'
AND ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID
AND NVL(SCH.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(SCH.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99) UNION SELECT SCH.ROWID ROW_ID
, SCH.TAX_CATEG_SLAB_ID
, SCH.TAX_CATEGORY_ID
, SCH.END_DATE_ACTIVE
, SCH.MIN_TAXABLE_BASIS
, SCH.LAST_UPDATE_DATE
, SCH.LAST_UPDATED_BY
, SCH.MAX_TAXABLE_BASIS
, TO_CHAR(NULL) TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, SCH.START_DATE_ACTIVE
, SCH.ORG_ID
, SCH.LAST_UPDATE_LOGIN
, SCH.CREATION_DATE
, SCH.CREATED_BY
, SCH.ATTRIBUTE_CATEGORY
, SCH.ATTRIBUTE1
, SCH.ATTRIBUTE2
, SCH.ATTRIBUTE3
, SCH.ATTRIBUTE4
, SCH.ATTRIBUTE5
, SCH.ATTRIBUTE6
, SCH.ATTRIBUTE7
, SCH.ATTRIBUTE8
, SCH.ATTRIBUTE9
, SCH.ATTRIBUTE10
, SCH.ATTRIBUTE11
, SCH.ATTRIBUTE12
, SCH.ATTRIBUTE13
, SCH.ATTRIBUTE14
, SCH.ATTRIBUTE15
FROM JL_ZZ_AR_TX_SCHEDULES SCH
WHERE SCH.TAX_CODE IS NULL