VIEW: APPS.JL_ZZ_AR_TX_CAT_DTL_V

Source

View Text - Preformatted

SELECT det.rowid row_id , det.tax_categ_dtl_id , det.tax_category_id , det.end_date_active , det.min_taxable_basis , det.last_update_date , det.last_updated_by , det.min_amount , det.min_percentage , art.tax_code , art.description , art.tax_rate , det.start_date_active , det.org_id, det.last_update_login , det.creation_date , det.created_by , det.attribute_category , det.attribute1 , det.attribute2 , det.attribute3 , det.attribute4 , det.attribute5 , det.attribute6 , det.attribute7 , det.attribute8 , det.attribute9 , det.attribute10 , det.attribute11 , det.attribute12 , det.attribute13 , det.attribute14 , det.attribute15 FROM jl_zz_ar_tx_cat_dtl det , ar_vat_tax_all_b art , ar_system_parameters_all sys WHERE art.tax_code = det.tax_code AND det.tax_code IS NOT NULL AND det.tax_category_id = decode(ltrim(art.global_attribute1 , '0123456789 '), null, to_number(art.global_attribute1), null) AND det.start_date_active <= nvl(art.end_date, to_date('4712/12/31', 'YYYY/MM/DD')) AND det.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(det.org_id,-99) = nvl(art.org_id,-99) AND nvl(det.org_id,-99) = nvl(sys.org_id,-99) UNION SELECT det.rowid row_id , det.tax_categ_dtl_id , det.tax_category_id , det.end_date_active , det.min_taxable_basis , det.last_update_date , det.last_updated_by , det.min_amount , det.min_percentage , to_char(null) tax_code , to_char(null) description , to_number(null) tax_rate , det.start_date_active , det.org_id, det.last_update_login , det.creation_date , det.created_by , det.attribute_category , det.attribute1 , det.attribute2 , det.attribute3 , det.attribute4 , det.attribute5 , det.attribute6 , det.attribute7 , det.attribute8 , det.attribute9 , det.attribute10 , det.attribute11 , det.attribute12 , det.attribute13 , det.attribute14 , det.attribute15 FROM jl_zz_ar_tx_cat_dtl det, ar_system_parameters_all sys WHERE det.tax_code IS NULL AND NVL(det.org_id,-99) = NVL(sys.org_id,-99)

View Text - HTML Formatted

SELECT DET.ROWID ROW_ID
, DET.TAX_CATEG_DTL_ID
, DET.TAX_CATEGORY_ID
, DET.END_DATE_ACTIVE
, DET.MIN_TAXABLE_BASIS
, DET.LAST_UPDATE_DATE
, DET.LAST_UPDATED_BY
, DET.MIN_AMOUNT
, DET.MIN_PERCENTAGE
, ART.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, DET.START_DATE_ACTIVE
, DET.ORG_ID
, DET.LAST_UPDATE_LOGIN
, DET.CREATION_DATE
, DET.CREATED_BY
, DET.ATTRIBUTE_CATEGORY
, DET.ATTRIBUTE1
, DET.ATTRIBUTE2
, DET.ATTRIBUTE3
, DET.ATTRIBUTE4
, DET.ATTRIBUTE5
, DET.ATTRIBUTE6
, DET.ATTRIBUTE7
, DET.ATTRIBUTE8
, DET.ATTRIBUTE9
, DET.ATTRIBUTE10
, DET.ATTRIBUTE11
, DET.ATTRIBUTE12
, DET.ATTRIBUTE13
, DET.ATTRIBUTE14
, DET.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CAT_DTL DET
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE ART.TAX_CODE = DET.TAX_CODE
AND DET.TAX_CODE IS NOT NULL
AND DET.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND DET.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND DET.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(DET.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(DET.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99) UNION SELECT DET.ROWID ROW_ID
, DET.TAX_CATEG_DTL_ID
, DET.TAX_CATEGORY_ID
, DET.END_DATE_ACTIVE
, DET.MIN_TAXABLE_BASIS
, DET.LAST_UPDATE_DATE
, DET.LAST_UPDATED_BY
, DET.MIN_AMOUNT
, DET.MIN_PERCENTAGE
, TO_CHAR(NULL) TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, DET.START_DATE_ACTIVE
, DET.ORG_ID
, DET.LAST_UPDATE_LOGIN
, DET.CREATION_DATE
, DET.CREATED_BY
, DET.ATTRIBUTE_CATEGORY
, DET.ATTRIBUTE1
, DET.ATTRIBUTE2
, DET.ATTRIBUTE3
, DET.ATTRIBUTE4
, DET.ATTRIBUTE5
, DET.ATTRIBUTE6
, DET.ATTRIBUTE7
, DET.ATTRIBUTE8
, DET.ATTRIBUTE9
, DET.ATTRIBUTE10
, DET.ATTRIBUTE11
, DET.ATTRIBUTE12
, DET.ATTRIBUTE13
, DET.ATTRIBUTE14
, DET.ATTRIBUTE15
FROM JL_ZZ_AR_TX_CAT_DTL DET
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE DET.TAX_CODE IS NULL
AND NVL(DET.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)