View: JL_ZZ_AR_TX_LOCN_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_ZZ_AR_TX_LOCN_V

View Text

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)

Columns