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