eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JL_ZZ_AR_TX_FSC_CLS_V

Source

View Text - Preformatted


SELECT fcl.rowid, fcl.fsc_cls_id, fcl.fiscal_classification_code, fcl.tax_category_id, brt.tax_category, fcl.tax_code, art.description, art.tax_rate, fcl.base_rate, fcl.start_date_active, fcl.end_date_active, fcl.enabled_flag, fcl.org_id, fcl.last_updated_by, fcl.last_update_date, fcl.last_update_login, fcl.creation_date, fcl.created_by, fcl.attribute_category, fcl.attribute1, fcl.attribute2, fcl.attribute3, fcl.attribute4, fcl.attribute5, fcl.attribute6, fcl.attribute7, fcl.attribute8, fcl.attribute9, fcl.attribute10, fcl.attribute11, fcl.attribute12, fcl.attribute13, fcl.attribute14, fcl.attribute15 FROM jl_zz_ar_tx_fsc_cls fcl, jl_zz_ar_tx_categ_all brt, ar_vat_tax_all_b art, ar_system_parameters_all sys WHERE fcl.tax_category_id = brt.tax_category_id AND brt.tax_rule_set = sys.global_attribute13 AND fcl.tax_code IS NOT NULL AND fcl.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 art.set_of_books_id = sys.set_of_books_id AND nvl(fcl.org_id,-99) = nvl(brt.org_id,-99) AND nvl(fcl.org_id,-99) = nvl(art.org_id,-99) AND nvl(fcl.org_id,-99) = nvl(sys.org_id,-99) AND fcl.tax_category_id = decode(ltrim(art.global_attribute1,'0123456789 '), null, to_number(art.global_attribute1), null) AND fcl.start_date_active <= NVL(art.end_date, to_date('4712/12/31', 'YYYY/MM/DD')) AND fcl.end_date_active >= art.start_date 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.global_attribute1 = art.global_attribute1 AND art1.start_date > art.start_date AND art1.start_date <= fcl.end_date_active) UNION SELECT fcl.rowid, fcl.fsc_cls_id, fcl.fiscal_classification_code, fcl.tax_category_id, brt.tax_category, fcl.tax_code, to_char(null) description, to_number(null) tax_rate, fcl.base_rate, fcl.start_date_active, fcl.end_date_active, fcl.enabled_flag, fcl.org_id, fcl.last_updated_by, fcl.last_update_date, fcl.last_update_login, fcl.creation_date, fcl.created_by, fcl.attribute_category, fcl.attribute1, fcl.attribute2, fcl.attribute3, fcl.attribute4, fcl.attribute5, fcl.attribute6, fcl.attribute7, fcl.attribute8, fcl.attribute9, fcl.attribute10, fcl.attribute11, fcl.attribute12, fcl.attribute13, fcl.attribute14, fcl.attribute15 FROM jl_zz_ar_tx_fsc_cls fcl, jl_zz_ar_tx_categ_all brt, ar_system_parameters_all sys WHERE fcl.tax_category_id = brt.tax_category_id AND brt.tax_rule_set = sys.global_attribute13 AND fcl.tax_code IS NULL AND nvl(fcl.org_id,-99) = nvl(brt.org_id,-99) AND nvl(fcl.org_id,-99) = nvl(sys.org_id,-99)

View Text - HTML Formatted

SELECT FCL.ROWID
, FCL.FSC_CLS_ID
, FCL.FISCAL_CLASSIFICATION_CODE
, FCL.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, FCL.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, FCL.BASE_RATE
, FCL.START_DATE_ACTIVE
, FCL.END_DATE_ACTIVE
, FCL.ENABLED_FLAG
, FCL.ORG_ID
, FCL.LAST_UPDATED_BY
, FCL.LAST_UPDATE_DATE
, FCL.LAST_UPDATE_LOGIN
, FCL.CREATION_DATE
, FCL.CREATED_BY
, FCL.ATTRIBUTE_CATEGORY
, FCL.ATTRIBUTE1
, FCL.ATTRIBUTE2
, FCL.ATTRIBUTE3
, FCL.ATTRIBUTE4
, FCL.ATTRIBUTE5
, FCL.ATTRIBUTE6
, FCL.ATTRIBUTE7
, FCL.ATTRIBUTE8
, FCL.ATTRIBUTE9
, FCL.ATTRIBUTE10
, FCL.ATTRIBUTE11
, FCL.ATTRIBUTE12
, FCL.ATTRIBUTE13
, FCL.ATTRIBUTE14
, FCL.ATTRIBUTE15
FROM JL_ZZ_AR_TX_FSC_CLS FCL
, JL_ZZ_AR_TX_CATEG_ALL BRT
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE FCL.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND FCL.TAX_CODE IS NOT NULL
AND FCL.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 ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID
AND NVL(FCL.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99)
AND NVL(FCL.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(FCL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND FCL.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND FCL.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND FCL.END_DATE_ACTIVE >= ART.START_DATE
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.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= FCL.END_DATE_ACTIVE) UNION SELECT FCL.ROWID
, FCL.FSC_CLS_ID
, FCL.FISCAL_CLASSIFICATION_CODE
, FCL.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, FCL.TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, FCL.BASE_RATE
, FCL.START_DATE_ACTIVE
, FCL.END_DATE_ACTIVE
, FCL.ENABLED_FLAG
, FCL.ORG_ID
, FCL.LAST_UPDATED_BY
, FCL.LAST_UPDATE_DATE
, FCL.LAST_UPDATE_LOGIN
, FCL.CREATION_DATE
, FCL.CREATED_BY
, FCL.ATTRIBUTE_CATEGORY
, FCL.ATTRIBUTE1
, FCL.ATTRIBUTE2
, FCL.ATTRIBUTE3
, FCL.ATTRIBUTE4
, FCL.ATTRIBUTE5
, FCL.ATTRIBUTE6
, FCL.ATTRIBUTE7
, FCL.ATTRIBUTE8
, FCL.ATTRIBUTE9
, FCL.ATTRIBUTE10
, FCL.ATTRIBUTE11
, FCL.ATTRIBUTE12
, FCL.ATTRIBUTE13
, FCL.ATTRIBUTE14
, FCL.ATTRIBUTE15
FROM JL_ZZ_AR_TX_FSC_CLS FCL
, JL_ZZ_AR_TX_CATEG_ALL BRT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE FCL.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND FCL.TAX_CODE IS NULL
AND NVL(FCL.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99)
AND NVL(FCL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)