[Home] [Help]
View: ZX_MCO_EO_STATUS_V
View Text
SELECT
ZSB.ROWID AS ROW_ID
,
ZSB.TAX_STATUS_ID
,
ZSB.TAX_STATUS_CODE
,
ZSB.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.OBJECT_VERSION_NUMBER
,
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
,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
,
ZMCAV.UPDATE_ACCESS
,
ZMCAV.DUPLICATE_ACCESS
FROM ZX_STATUS_B ZSB
,
ZX_STATUS_TL ZST
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
,
ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE ZST.TAX_STATUS_ID = ZSB.TAX_STATUS_ID
AND ZST.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZSB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE = ZSB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID = ZSB.CONTENT_OWNER_ID