FND Design Data [Home] [Help]

View: JL_ZZ_AR_TX_RULES_V

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

SELECT RUL.ROWID
, RUL.RULE_ID
, RUL.TAX_RULE_LEVEL
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(RUL.TAX_RULE_LEVEL
, 'JLZZ_AR_TX_RULES_LEVEL')
, 1
, 80) LEVEL_DESC
, RUL.RULE
, RUL.PRIORITY
, RUL.DESCRIPTION
, RUL.TAX_CATEGORY_ID
, BRT.TAX_CATEGORY
, BRT.CUS_TAX_ATTRIBUTE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(BRT.CUS_TAX_ATTRIBUTE
, 'CONTRIBUTOR_ATTRIBUTE')
, 1
, 80) ATTR_NAME_DESC
, RUL.CONTRIBUTOR_TYPE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(RUL.CONTRIBUTOR_TYPE
, 'JLZZ_AR_TX_ATTR_VALUE')
, 1
, 80) CONTRIBUTOR_DESC
, RUL.CUST_TRX_TYPE_ID
, CTT.NAME
, RUL.ORG_ID
, RUL.LAST_UPDATED_BY
, RUL.LAST_UPDATE_DATE
, RUL.LAST_UPDATE_LOGIN
, RUL.CREATION_DATE
, RUL.CREATED_BY
FROM JL_ZZ_AR_TX_RULES RUL
, RA_CUST_TRX_TYPES_ALL CTT
, JL_ZZ_AR_TX_CATEG_ALL BRT
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE RUL.TAX_CATEGORY_ID = BRT.TAX_CATEGORY_ID
AND BRT.TAX_RULE_SET = SYS.GLOBAL_ATTRIBUTE13
AND RUL.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND NVL(RUL.ORG_ID
, -99) = NVL(CTT.ORG_ID
, -99)
AND NVL(RUL.ORG_ID
, -99) = NVL(BRT.ORG_ID
, -99)
AND NVL(RUL.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)

Columns

Name
ROW_ID
RULE_ID
TAX_RULE_LEVEL
LEVEL_DESC
RULE
PRIORITY
DESCRIPTION
TAX_CATEGORY_ID
TAX_CATEGORY
ATTRIBUTE_NAME
ATTR_NAME_DESC
CONTRIBUTOR_TYPE
CONTRIBUTOR_DESC
CUST_TRX_TYPE_ID
CUST_TRX_DESC
ORG_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY