VIEW: APPS.JL_ZZ_AR_TX_NAT_RAT_V

Source

View Text - Preformatted

SELECT tnr.rowid row_id, tnr.txn_nature_id txn_nature_id, tcav.tax_categ_attr_val_id tax_categ_attr_val_id, tcav.tax_category_id tax_category_id, tcav.tax_attribute_name tax_attribute_name, tcav.tax_attribute_value tax_attribute_value, tcav.attr_val_desc meaning, tnr.end_date_active end_date_active, tnr.tax_code tax_code, art.description tax_description, art.tax_rate tax_rate, tnr.min_taxable_basis min_taxable_basis, tnr.min_amount min_amount, tnr.min_percentage min_percentage, tnr.base_rate base_rate, tnr.start_date_active start_date_active, tnr.org_id, tnr.creation_date creation_date, tnr.created_by created_by, tnr.last_update_date last_update_date, tnr.last_updated_by last_updated_by, tnr.last_update_login last_update_login, tnr.attribute_category, tnr.attribute1, tnr.attribute2, tnr.attribute3, tnr.attribute4, tnr.attribute5, tnr.attribute6, tnr.attribute7, tnr.attribute8, tnr.attribute9, tnr.attribute10, tnr.attribute11, tnr.attribute12, tnr.attribute13, tnr.attribute14, tnr.attribute15 FROM jl_zz_ar_tx_att_val_v tcav, jl_zz_ar_tx_nat_rat tnr, ar_vat_tax_all art, ar_system_parameters_all sys WHERE tcav.tax_categ_attr_val_id = tnr.tax_categ_attr_val_id AND tcav.tax_attribute_type = 'TRANSACTION_ATTRIBUTE' AND tnr.tax_code = art.tax_code AND NVL(art.tax_type, 'VAT') = 'VAT' AND NVL(art.tax_class, 'O') = 'O' AND NVL(art.enabled_flag, 'Y') = 'Y' AND NVL(art.set_of_books_id,sys.set_of_books_id) = sys.set_of_books_id AND tcav.tax_category_id = decode(ltrim(art.global_attribute1, '0123456789 '), null, to_number(art.global_attribute1), null) AND tnr.start_date_active <= NVL(art.end_date, to_date('4712/12/31', 'YYYY/MM/DD')) AND tnr.end_date_active >= art.start_date AND NVL(tnr.org_id,-99) = NVL(tcav.org_id,-99) AND NVL(tnr.org_id,-99) = NVL(art.org_id,-99) AND NVL(tnr.org_id,-99) = NVL(sys.org_id,-99) AND NOT EXISTS (select 1 from ar_vat_tax art1 where art1.tax_code = art.tax_code AND art1.set_of_books_id = art.set_of_books_id AND NVL(art1.tax_type, 'VAT') = 'VAT' AND NVL(art1.tax_class, 'O') = 'O' AND NVL(art1.enabled_flag, 'Y') = 'Y' AND art1.tax_type = art.tax_type AND art1.global_attribute1 = art.global_attribute1 AND art1.start_date > art.start_date AND art1.start_date <= tnr.end_date_active)

View Text - HTML Formatted

SELECT TNR.ROWID ROW_ID
, TNR.TXN_NATURE_ID TXN_NATURE_ID
, TCAV.TAX_CATEG_ATTR_VAL_ID TAX_CATEG_ATTR_VAL_ID
, TCAV.TAX_CATEGORY_ID TAX_CATEGORY_ID
, TCAV.TAX_ATTRIBUTE_NAME TAX_ATTRIBUTE_NAME
, TCAV.TAX_ATTRIBUTE_VALUE TAX_ATTRIBUTE_VALUE
, TCAV.ATTR_VAL_DESC MEANING
, TNR.END_DATE_ACTIVE END_DATE_ACTIVE
, TNR.TAX_CODE TAX_CODE
, ART.DESCRIPTION TAX_DESCRIPTION
, ART.TAX_RATE TAX_RATE
, TNR.MIN_TAXABLE_BASIS MIN_TAXABLE_BASIS
, TNR.MIN_AMOUNT MIN_AMOUNT
, TNR.MIN_PERCENTAGE MIN_PERCENTAGE
, TNR.BASE_RATE BASE_RATE
, TNR.START_DATE_ACTIVE START_DATE_ACTIVE
, TNR.ORG_ID
, TNR.CREATION_DATE CREATION_DATE
, TNR.CREATED_BY CREATED_BY
, TNR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TNR.LAST_UPDATED_BY LAST_UPDATED_BY
, TNR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TNR.ATTRIBUTE_CATEGORY
, TNR.ATTRIBUTE1
, TNR.ATTRIBUTE2
, TNR.ATTRIBUTE3
, TNR.ATTRIBUTE4
, TNR.ATTRIBUTE5
, TNR.ATTRIBUTE6
, TNR.ATTRIBUTE7
, TNR.ATTRIBUTE8
, TNR.ATTRIBUTE9
, TNR.ATTRIBUTE10
, TNR.ATTRIBUTE11
, TNR.ATTRIBUTE12
, TNR.ATTRIBUTE13
, TNR.ATTRIBUTE14
, TNR.ATTRIBUTE15
FROM JL_ZZ_AR_TX_ATT_VAL_V TCAV
, JL_ZZ_AR_TX_NAT_RAT TNR
, AR_VAT_TAX_ALL ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TCAV.TAX_CATEG_ATTR_VAL_ID = TNR.TAX_CATEG_ATTR_VAL_ID
AND TCAV.TAX_ATTRIBUTE_TYPE = 'TRANSACTION_ATTRIBUTE'
AND TNR.TAX_CODE = ART.TAX_CODE
AND NVL(ART.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART.TAX_CLASS
, 'O') = 'O'
AND NVL(ART.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(ART.SET_OF_BOOKS_ID
, SYS.SET_OF_BOOKS_ID) = SYS.SET_OF_BOOKS_ID
AND TCAV.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND TNR.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND TNR.END_DATE_ACTIVE >= ART.START_DATE
AND NVL(TNR.ORG_ID
, -99) = NVL(TCAV.ORG_ID
, -99)
AND NVL(TNR.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(TNR.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND NOT EXISTS (SELECT 1
FROM AR_VAT_TAX ART1
WHERE ART1.TAX_CODE = ART.TAX_CODE
AND ART1.SET_OF_BOOKS_ID = ART.SET_OF_BOOKS_ID
AND NVL(ART1.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART1.TAX_CLASS
, 'O') = 'O'
AND NVL(ART1.ENABLED_FLAG
, 'Y') = 'Y'
AND ART1.TAX_TYPE = ART.TAX_TYPE
AND ART1.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= TNR.END_DATE_ACTIVE)