View: ZX_MCO_LV_RULES_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_MCO_LV_RULES_V

View Text

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_APPLICATION_ID
, ZRB.PROGRAM_ID
, 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 FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99)) ORDER BY ZSD.VIEW_OPTIONS_CODE