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_EXC_FSC_V

Source

View Text - Preformatted


SELECT tex.rowid, tex.exc_fsc_id, tex.ship_from_code, val1.geography_name, tex.ship_to_segment_id, val2.geography_code, val2.geography_name, tex.fiscal_classification_code, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tex.fiscal_classification_code, 'JLZZ_AR_TX_FISCAL_CLASS_CODE'),1,80), tex.tax_category_id, brt.tax_category, tex.base_rate, tex.tax_code, art.description, art.tax_rate, tex.start_date_active, tex.end_date_active, tex.org_id, tex.last_updated_by, tex.last_update_date, tex.last_update_login, tex.creation_date, tex.created_by, tex.attribute_category, tex.attribute1, tex.attribute2, tex.attribute3, tex.attribute4, tex.attribute5, tex.attribute6, tex.attribute7, tex.attribute8, tex.attribute9, tex.attribute10, tex.attribute11, tex.attribute12, tex.attribute13, tex.attribute14, tex.attribute15 FROM jl_zz_ar_tx_exc_fsc tex, jl_zz_ar_tx_categ_all brt, ar_vat_tax_all_b art, ar_system_parameters_all sys, hz_geographies val1, hz_geographies val2 WHERE tex.ship_to_segment_id = val2.geography_id AND tex.ship_from_code = val1.geography_code AND val1.country_code = sys.default_country AND val1.geography_type = sys.global_attribute9 AND tex.tax_category_id = brt.tax_category_id AND brt.tax_rule_set = sys.global_attribute13 AND tex.tax_code IS NOT NULL AND tex.tax_code = art.tax_code AND art.set_of_books_id = sys.set_of_books_id AND NVL(art.tax_type, 'VAT') = 'VAT' AND NVL(art.tax_class, 'O') = 'O' AND NVL(art.enabled_flag, 'Y') = 'Y' AND tex.tax_category_id = decode(ltrim(art.global_attribute1,'0123456789 '), null, to_number(art.global_attribute1), null) AND tex.start_date_active <= NVL(art.end_date,to_date('4712/12/31', 'YYYY/MM/DD')) AND tex.end_date_active >= art.start_date AND NVL(tex.org_id,-99) = NVL(brt.org_id,-99) AND NVL(tex.org_id,-99) = NVL(art.org_id,-99) AND NVL(tex.org_id,-99) = NVL(sys.org_id,-99) /*AND NVL(tex.org_id,-99) = NVL(val2.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.global_attribute1 = art.global_attribute1 AND art1.start_date > art.start_date AND art1.start_date <= tex.end_date_active) UNION SELECT tex.rowid, tex.exc_fsc_id, tex.ship_from_code, val1.geography_name, tex.ship_to_segment_id, val2.geography_code, val2.geography_name, tex.fiscal_classification_code, substr(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tex.fiscal_classification_code, 'JLZZ_AR_TX_FISCAL_CLASS_CODE'),1,80), tex.tax_category_id, brt.tax_category, tex.base_rate, tex.tax_code, to_char(null) description, to_number(null) tax_rate, tex.start_date_active, tex.end_date_active, tex.org_id, tex.last_updated_by, tex.last_update_date, tex.last_update_login, tex.creation_date, tex.created_by, tex.attribute_category, tex.attribute1, tex.attribute2, tex.attribute3, tex.attribute4, tex.attribute5, tex.attribute6, tex.attribute7, tex.attribute8, tex.attribute9, tex.attribute10, tex.attribute11, tex.attribute12, tex.attribute13, tex.attribute14, tex.attribute15 FROM jl_zz_ar_tx_exc_fsc tex, jl_zz_ar_tx_categ_all brt, hz_geographies val1, hz_geographies val2, ar_system_parameters_all sys WHERE tex.ship_to_segment_id = val2.geography_id AND tex.ship_from_code = val1.geography_code AND val1.country_code = sys.default_country AND val1.geography_type = sys.global_attribute9 AND tex.tax_category_id = brt.tax_category_id AND brt.tax_rule_set = sys.global_attribute13 AND tex.tax_code IS NULL AND NVL(tex.org_id,-99) = NVL(brt.org_id,-99) /*AND NVL(tex.org_id,-99) = NVL(val2.org_id,-99)*/ AND NVL(tex.org_id,-99) = NVL(sys.org_id,-99)

View Text - HTML Formatted

SELECT TEX.ROWID
, TEX.EXC_FSC_ID
, TEX.SHIP_FROM_CODE
, VAL1.GEOGRAPHY_NAME
, TEX.SHIP_TO_SEGMENT_ID
, VAL2.GEOGRAPHY_CODE
, VAL2.GEOGRAPHY_NAME
, TEX.FISCAL_CLASSIFICATION_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TEX.FISCAL_CLASSIFICATION_CODE
, 'JLZZ_AR_TX_FISCAL_CLASS_CODE')
, 1
, 80)
, TEX.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, TEX.BASE_RATE
, TEX.TAX_CODE
, ART.DESCRIPTION
, ART.TAX_RATE
, TEX.START_DATE_ACTIVE
, TEX.END_DATE_ACTIVE
, TEX.ORG_ID
, TEX.LAST_UPDATED_BY
, TEX.LAST_UPDATE_DATE
, TEX.LAST_UPDATE_LOGIN
, TEX.CREATION_DATE
, TEX.CREATED_BY
, TEX.ATTRIBUTE_CATEGORY
, TEX.ATTRIBUTE1
, TEX.ATTRIBUTE2
, TEX.ATTRIBUTE3
, TEX.ATTRIBUTE4
, TEX.ATTRIBUTE5
, TEX.ATTRIBUTE6
, TEX.ATTRIBUTE7
, TEX.ATTRIBUTE8
, TEX.ATTRIBUTE9
, TEX.ATTRIBUTE10
, TEX.ATTRIBUTE11
, TEX.ATTRIBUTE12
, TEX.ATTRIBUTE13
, TEX.ATTRIBUTE14
, TEX.ATTRIBUTE15
FROM JL_ZZ_AR_TX_EXC_FSC TEX
, JL_ZZ_AR_TX_CATEG_ALL BRT
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
, HZ_GEOGRAPHIES VAL1
, HZ_GEOGRAPHIES VAL2
WHERE TEX.SHIP_TO_SEGMENT_ID = VAL2.GEOGRAPHY_ID
AND TEX.SHIP_FROM_CODE = VAL1.GEOGRAPHY_CODE
AND VAL1.COUNTRY_CODE = SYS.DEFAULT_COUNTRY
AND VAL1.GEOGRAPHY_TYPE = SYS.GLOBAL_ATTRIBUTE9
AND TEX.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND TEX.TAX_CODE IS NOT NULL
AND TEX.TAX_CODE = ART.TAX_CODE
AND ART.SET_OF_BOOKS_ID = SYS.SET_OF_BOOKS_ID
AND NVL(ART.TAX_TYPE
, 'VAT') = 'VAT'
AND NVL(ART.TAX_CLASS
, 'O') = 'O'
AND NVL(ART.ENABLED_FLAG
, 'Y') = 'Y'
AND TEX.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND TEX.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND TEX.END_DATE_ACTIVE >= ART.START_DATE
AND NVL(TEX.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99)
AND NVL(TEX.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(TEX.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99) /*AND NVL(TEX.ORG_ID
, -99) = NVL(VAL2.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.GLOBAL_ATTRIBUTE1 = ART.GLOBAL_ATTRIBUTE1
AND ART1.START_DATE > ART.START_DATE
AND ART1.START_DATE <= TEX.END_DATE_ACTIVE) UNION SELECT TEX.ROWID
, TEX.EXC_FSC_ID
, TEX.SHIP_FROM_CODE
, VAL1.GEOGRAPHY_NAME
, TEX.SHIP_TO_SEGMENT_ID
, VAL2.GEOGRAPHY_CODE
, VAL2.GEOGRAPHY_NAME
, TEX.FISCAL_CLASSIFICATION_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TEX.FISCAL_CLASSIFICATION_CODE
, 'JLZZ_AR_TX_FISCAL_CLASS_CODE')
, 1
, 80)
, TEX.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, TEX.BASE_RATE
, TEX.TAX_CODE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, TEX.START_DATE_ACTIVE
, TEX.END_DATE_ACTIVE
, TEX.ORG_ID
, TEX.LAST_UPDATED_BY
, TEX.LAST_UPDATE_DATE
, TEX.LAST_UPDATE_LOGIN
, TEX.CREATION_DATE
, TEX.CREATED_BY
, TEX.ATTRIBUTE_CATEGORY
, TEX.ATTRIBUTE1
, TEX.ATTRIBUTE2
, TEX.ATTRIBUTE3
, TEX.ATTRIBUTE4
, TEX.ATTRIBUTE5
, TEX.ATTRIBUTE6
, TEX.ATTRIBUTE7
, TEX.ATTRIBUTE8
, TEX.ATTRIBUTE9
, TEX.ATTRIBUTE10
, TEX.ATTRIBUTE11
, TEX.ATTRIBUTE12
, TEX.ATTRIBUTE13
, TEX.ATTRIBUTE14
, TEX.ATTRIBUTE15
FROM JL_ZZ_AR_TX_EXC_FSC TEX
, JL_ZZ_AR_TX_CATEG_ALL BRT
, HZ_GEOGRAPHIES VAL1
, HZ_GEOGRAPHIES VAL2
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE TEX.SHIP_TO_SEGMENT_ID = VAL2.GEOGRAPHY_ID
AND TEX.SHIP_FROM_CODE = VAL1.GEOGRAPHY_CODE
AND VAL1.COUNTRY_CODE = SYS.DEFAULT_COUNTRY
AND VAL1.GEOGRAPHY_TYPE = SYS.GLOBAL_ATTRIBUTE9
AND TEX.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND TEX.TAX_CODE IS NULL
AND NVL(TEX.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99) /*AND NVL(TEX.ORG_ID
, -99) = NVL(VAL2.ORG_ID
, -99)*/
AND NVL(TEX.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)