Product: | JL - Latin America Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JL_ZZ_AR_TX_ATT_VAL_V |
SELECT VAL.ROWID ROW_ID
, VAL.TAX_CATEGORY_ID
, VAL.TAX_CATEG_ATTR_VAL_ID
, VAL.TAX_ATTRIBUTE_TYPE
, VAL.TAX_ATTRIBUTE_NAME
, VAL.TAX_ATTRIBUTE_VALUE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(VAL.TAX_ATTRIBUTE_VALUE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80) ATTR_VAL_DESC
, VAL.TAX_ATTR_VALUE_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(VAL.TAX_ATTR_VALUE_CODE
, DECODE(VAL.TAX_ATTRIBUTE_TYPE
, 'CONTRIBUTOR_ATTRIBUTE'
, 'JLAR_AP_SUPP_CONDITION_CODE'
, 'TRANSACTION_ATTRIBUTE'
, 'JLAR_TAX_AUTHORITY_CATEGORY'
, 'X'))
, 1
, 80) TAX_ATTR_VALUE_MEANING
, VAL.DEFAULT_TO_CLASS
, VAL.ORG_ID
, VAL.CREATION_DATE
, VAL.CREATED_BY
, VAL.LAST_UPDATE_DATE
, VAL.LAST_UPDATE_LOGIN
, VAL.LAST_UPDATED_BY
, VAL.ATTRIBUTE_CATEGORY
, VAL.ATTRIBUTE1
, VAL.ATTRIBUTE2
, VAL.ATTRIBUTE3
, VAL.ATTRIBUTE4
, VAL.ATTRIBUTE5
, VAL.ATTRIBUTE6
, VAL.ATTRIBUTE7
, VAL.ATTRIBUTE8
, VAL.ATTRIBUTE9
, VAL.ATTRIBUTE10
, VAL.ATTRIBUTE11
, VAL.ATTRIBUTE12
, VAL.ATTRIBUTE13
, VAL.ATTRIBUTE14
, VAL.ATTRIBUTE15
FROM JL_ZZ_AR_TX_ATT_VAL_ALL VAL
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE NVL(VAL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)