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_LOCN_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

SELECT LOC.ROWID
, LOC.LOCN_ID
, LOC.SHIP_FROM_CODE
, VAL1.GEOGRAPHY_NAME
, LOC.SHIP_TO_SEGMENT_ID
, VAL2.GEOGRAPHY_CODE
, VAL2.GEOGRAPHY_NAME
, LOC.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, LOC.TAX_CODE
, LOC.BASE_RATE
, ART.DESCRIPTION
, ART.TAX_RATE
, LOC.TRIB_SUBST_INSCRIPTION
, LOC.START_DATE_ACTIVE
, LOC.END_DATE_ACTIVE
, LOC.ORG_ID
, LOC.LAST_UPDATED_BY
, LOC.LAST_UPDATE_DATE
, LOC.LAST_UPDATE_LOGIN
, LOC.CREATION_DATE
, LOC.CREATED_BY
, LOC.ATTRIBUTE_CATEGORY
, LOC.ATTRIBUTE1
, LOC.ATTRIBUTE2
, LOC.ATTRIBUTE3
, LOC.ATTRIBUTE4
, LOC.ATTRIBUTE5
, LOC.ATTRIBUTE6
, LOC.ATTRIBUTE7
, LOC.ATTRIBUTE8
, LOC.ATTRIBUTE9
, LOC.ATTRIBUTE10
, LOC.ATTRIBUTE11
, LOC.ATTRIBUTE12
, LOC.ATTRIBUTE13
, LOC.ATTRIBUTE14
, LOC.ATTRIBUTE15
FROM JL_ZZ_AR_TX_LOCN LOC
, JL_ZZ_AR_TX_CATEG_ALL BRT
, HZ_GEOGRAPHIES VAL1
, HZ_GEOGRAPHIES VAL2
, AR_VAT_TAX_ALL_B ART
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE LOC.SHIP_TO_SEGMENT_ID = VAL2.GEOGRAPHY_ID
AND LOC.SHIP_FROM_CODE = VAL1.GEOGRAPHY_CODE
AND VAL1.COUNTRY_CODE = SYS.DEFAULT_COUNTRY
AND VAL1.GEOGRAPHY_TYPE = SYS.GLOBAL_ATTRIBUTE9
AND LOC.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND LOC.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 NVL(LOC.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99) /*AND NVL(LOC.ORG_ID
, -99) = NVL(VAL2.ORG_ID
, -99)*/
AND NVL(LOC.ORG_ID
, -99) = NVL(ART.ORG_ID
, -99)
AND NVL(LOC.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)
AND LOC.TAX_CODE IS NOT NULL
AND LOC.TAX_CATEGORY_ID = DECODE(LTRIM(ART.GLOBAL_ATTRIBUTE1
, '0123456789 ')
, NULL
, TO_NUMBER(ART.GLOBAL_ATTRIBUTE1)
, NULL)
AND LOC.START_DATE_ACTIVE <= NVL(ART.END_DATE
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND LOC.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 <= LOC.END_DATE_ACTIVE) UNION SELECT LOC.ROWID
, LOC.LOCN_ID
, LOC.SHIP_FROM_CODE
, VAL1.GEOGRAPHY_NAME
, LOC.SHIP_TO_SEGMENT_ID
, VAL2.GEOGRAPHY_CODE
, VAL2.GEOGRAPHY_NAME
, LOC.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, LOC.TAX_CODE
, LOC.BASE_RATE
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) TAX_RATE
, LOC.TRIB_SUBST_INSCRIPTION
, LOC.START_DATE_ACTIVE
, LOC.END_DATE_ACTIVE
, LOC.ORG_ID
, LOC.LAST_UPDATED_BY
, LOC.LAST_UPDATE_DATE
, LOC.LAST_UPDATE_LOGIN
, LOC.CREATION_DATE
, LOC.CREATED_BY
, LOC.ATTRIBUTE_CATEGORY
, LOC.ATTRIBUTE1
, LOC.ATTRIBUTE2
, LOC.ATTRIBUTE3
, LOC.ATTRIBUTE4
, LOC.ATTRIBUTE5
, LOC.ATTRIBUTE6
, LOC.ATTRIBUTE7
, LOC.ATTRIBUTE8
, LOC.ATTRIBUTE9
, LOC.ATTRIBUTE10
, LOC.ATTRIBUTE11
, LOC.ATTRIBUTE12
, LOC.ATTRIBUTE13
, LOC.ATTRIBUTE14
, LOC.ATTRIBUTE15
FROM JL_ZZ_AR_TX_LOCN LOC
, JL_ZZ_AR_TX_CATEG_ALL BRT
, HZ_GEOGRAPHIES VAL1
, HZ_GEOGRAPHIES VAL2
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE LOC.SHIP_TO_SEGMENT_ID = VAL2.GEOGRAPHY_ID
AND LOC.SHIP_FROM_CODE = VAL1.GEOGRAPHY_CODE
AND VAL1.COUNTRY_CODE = SYS.DEFAULT_COUNTRY
AND VAL1.GEOGRAPHY_TYPE = SYS.GLOBAL_ATTRIBUTE9
AND LOC.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND LOC.TAX_CODE IS NULL
AND NVL(LOC.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99) /*AND NVL(LOC.ORG_ID
, -99) = NVL(VAL2.ORG_ID
, -99)*/
AND NVL(LOC.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)