[Home] [Help]
View: ZX_MCO_EO_RULES_V
View Text
SELECT
ZRB.ROWID AS ROW_ID
,
ZRB.TAX_RULE_ID
,
ZRB.CONTENT_OWNER_ID
,
ZRB.TAX_RULE_CODE
,
ZRB.TAX
,
ZRB.TAX_REGIME_CODE
,
ZRB.SERVICE_TYPE_CODE
,
ZRB.RECOVERY_TYPE_CODE
,
ZRB.PRIORITY
,
ZRB.DET_FACTOR_TEMPL_CODE
,
ZRB.SYSTEM_DEFAULT_FLAG
,
ZRB.EFFECTIVE_FROM
,
ZRB.EFFECTIVE_TO
,
ZRB.ENABLED_FLAG
,
ZRB.APPLICATION_ID
,
ZRB.RECORD_TYPE_CODE
,
ZRB.TAX_EVENT_CLASS_CODE
,
ZRB.CREATED_BY
,
ZRB.CREATION_DATE
,
ZRB.LAST_UPDATED_BY
,
ZRB.LAST_UPDATE_DATE
,
ZRB.LAST_UPDATE_LOGIN
,
ZRB.REQUEST_ID
,
ZRB.PROGRAM_APPLICATION_ID
,
ZRB.PROGRAM_ID
,
ZRB.PROGRAM_LOGIN_ID
,
ZRT.TAX_RULE_NAME
,
ZRT.TAX_RULE_DESC
,
ZRB.OBJECT_VERSION_NUMBER
,
ZRB.DETERMINING_FACTOR_CQ_CODE
,
ZRB.GEOGRAPHY_TYPE
,
ZRB.GEOGRAPHY_ID
,
ZRB.TAX_LAW_REF_CODE
,
ZRT.TAX_LAW_REF_DESC
,
ZRB.LAST_UPDATE_MODE_FLAG
,
ZRB.NEVER_BEEN_ENABLED_FLAG
,
ZRB.EVENT_CLASS_MAPPING_ID
,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
FROM ZX_RULES_B ZRB
,
ZX_RULES_TL ZRT
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
,
ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE ZRT.TAX_RULE_ID = ZRB.TAX_RULE_ID
AND ZRT.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID