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