ZX_MCO_EO_RULES_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_RULE_ID CONTENT_OWNER_ID TAX_RULE_CODE TAX TAX_REGIME_CODE SERVICE_TYPE_CODE RECOVERY_TYPE_CODE PRIORITY DET_FACTOR_TEMPL_CODE SYSTEM_DEFAULT_FLAG EFFECTIVE_FROM EFFECTIVE_TO ENABLED_FLAG APPLICATION_ID RECORD_TYPE_CODE TAX_EVENT_CLASS_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID TAX_RULE_NAME TAX_RULE_DESC OBJECT_VERSION_NUMBER DETERMINING_FACTOR_CQ_CODE GEOGRAPHY_TYPE GEOGRAPHY_ID TAX_LAW_REF_CODE TAX_LAW_REF_DESC LAST_UPDATE_MODE_FLAG NEVER_BEEN_ENABLED_FLAG EVENT_CLASS_MAPPING_ID CONTENT_OWNER_NAME TAX_STATUS_CODE

Query

SQL_Statement

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_APP_NAME, ZRB.PROGRAM_NAME, 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, ZRB.TAX_STATUS_CODE 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