ZX_MCO_LV_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 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 VIEW_OPTIONS_CODE

Query

SQL_Statement

SELECT DISTINCT ZRB.ROWID AS ROW_ID, ZRB.TAX_RULE_ID, ZSD.FIRST_PTY_ORG_ID 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.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, ZSD.VIEW_OPTIONS_CODE FROM ZX_RULES_B ZRB, ZX_RULES_TL ZRT, ZX_SUBSCRIPTION_DETAILS ZSD, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV WHERE ZRT.TAX_RULE_ID = ZRB.TAX_RULE_ID AND ZRT.LANGUAGE = USERENV('LANG') AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID AND ZSD.VIEW_OPTIONS_CODE IN ('VFC','VFR') AND ((ZSD.FIRST_PTY_ORG_ID = -99 AND ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99)) ORDER BY ZSD.VIEW_OPTIONS_CODE