FND Design Data [Home] [Help]

View: JL_ZZ_AR_TX_EXC_FSC_V

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

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)

Columns

Name
ROW_ID
EXC_FSC_ID
SHIP_FROM_CODE
SHIP_FROM_STATE
SHIP_TO_SEGMENT_ID
SHIP_TO_CODE
SHIP_TO_STATE
FISCAL_CLASSIFICATION_CODE
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