[Home] [Help]
View: ZX_MCO_LV_STATUS_V
View Text
SELECT DISTINCT
ZSB.ROWID AS ROW_ID
,
ZSB.TAX_STATUS_ID
,
ZSB.TAX_STATUS_CODE
,
ZSD.FIRST_PTY_ORG_ID CONTENT_OWNER_ID
,
ZSB.EFFECTIVE_FROM
,
ZSB.EFFECTIVE_TO
,
ZSB.TAX
,
ZSB.TAX_REGIME_CODE
,
ZSB.RULE_BASED_RATE_FLAG
,
ZSB.ALLOW_RATE_OVERRIDE_FLAG
,
ZSB.ALLOW_EXEMPTIONS_FLAG
,
ZSB.ALLOW_EXCEPTIONS_FLAG
,
ZSB.DEFAULT_STATUS_FLAG
,
ZSB.DEFAULT_FLG_EFFECTIVE_FROM
,
ZSB.DEFAULT_FLG_EFFECTIVE_TO
,
ZSB.DEF_REC_SETTLEMENT_OPTION_CODE
,
ZSB.RECORD_TYPE_CODE
,
ZSB.CREATED_BY
,
ZSB.CREATION_DATE
,
ZSB.LAST_UPDATED_BY
,
ZSB.LAST_UPDATE_DATE
,
ZSB.LAST_UPDATE_LOGIN
,
ZSB.REQUEST_ID
,
ZSB.PROGRAM_APPLICATION_ID
,
ZSB.PROGRAM_ID
,
ZSB.PROGRAM_LOGIN_ID
,
ZSB.ATTRIBUTE1
,
ZSB.ATTRIBUTE2
,
ZSB.ATTRIBUTE3
,
ZSB.ATTRIBUTE4
,
ZSB.ATTRIBUTE5
,
ZSB.ATTRIBUTE6
,
ZSB.ATTRIBUTE7
,
ZSB.ATTRIBUTE8
,
ZSB.ATTRIBUTE9
,
ZSB.ATTRIBUTE10
,
ZSB.ATTRIBUTE11
,
ZSB.ATTRIBUTE12
,
ZSB.ATTRIBUTE13
,
ZSB.ATTRIBUTE14
,
ZSB.ATTRIBUTE15
,
ZSB.ATTRIBUTE_CATEGORY
,
ZST.TAX_STATUS_NAME
,
ZSD.VIEW_OPTIONS_CODE
FROM ZX_STATUS_B ZSB
,
ZX_STATUS_TL ZST
,
ZX_SUBSCRIPTION_DETAILS ZSD
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
WHERE ZST.TAX_STATUS_ID = ZSB.TAX_STATUS_ID
AND ZST.LANGUAGE = USERENV('LANG')
AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZSB.CONTENT_OWNER_ID
AND ZSD.TAX_REGIME_CODE = ZSB.TAX_REGIME_CODE
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZSB.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