FND Design Data [Home] [Help]

View: JL_ZZ_AR_TX_EXC_ITM_V

Product: JL - Latin America Localizations
Description:
Implementation/DBA Data: ViewAPPS.JL_ZZ_AR_TX_EXC_ITM_V
View Text

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

Columns

Name
ROW_ID
EXC_ITM_ID
SHIP_FROM_CODE
SHIP_FROM_STATE
SHIP_TO_SEGMENT_ID
SHIP_TO_CODE
SHIP_TO_STATE
INVENTORY_ITEM_ID
ORGANIZATION_ID
DESCRIPTION
TAX_CATEGORY_ID
TAX_CATEGORY
BASE_RATE
TAX_CODE
TAX_DESCRIPTION
TAX_RATE
START_DATE_ACTIVE
END_DATE_ACTIVE
ORG_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15