[Home] [Help]
View: ZX_SCO_STATUS_B_V
View Text
SELECT
A.ROWID ROW_ID
,
A.TAX_STATUS_ID
,
A.TAX_STATUS_CODE
,
A.CONTENT_OWNER_ID
,
A.EFFECTIVE_FROM
,
A.EFFECTIVE_TO
,
A.TAX
,
A.TAX_REGIME_CODE
,
A.RULE_BASED_RATE_FLAG
,
A.ALLOW_RATE_OVERRIDE_FLAG
,
A.ALLOW_EXEMPTIONS_FLAG
,
A.ALLOW_EXCEPTIONS_FLAG
,
A.DEFAULT_STATUS_FLAG
,
A.DEFAULT_FLG_EFFECTIVE_FROM
,
A.DEFAULT_FLG_EFFECTIVE_TO
,
A.DEF_REC_SETTLEMENT_OPTION_CODE
,
A.OBJECT_VERSION_NUMBER
,
A.RECORD_TYPE_CODE
,
A.CREATED_BY
,
A.CREATION_DATE
,
A.LAST_UPDATED_BY
,
A.LAST_UPDATE_DATE
,
A.LAST_UPDATE_LOGIN
,
A.REQUEST_ID
,
A.PROGRAM_APPLICATION_ID
,
A.PROGRAM_ID
,
A.PROGRAM_LOGIN_ID
,
A.ATTRIBUTE1
,
A.ATTRIBUTE2
,
A.ATTRIBUTE3
,
A.ATTRIBUTE4
,
A.ATTRIBUTE5
,
A.ATTRIBUTE6
,
A.ATTRIBUTE7
,
A.ATTRIBUTE8
,
A.ATTRIBUTE9
,
A.ATTRIBUTE10
,
A.ATTRIBUTE11
,
A.ATTRIBUTE12
,
A.ATTRIBUTE13
,
A.ATTRIBUTE14
,
A.ATTRIBUTE15
,
A.ATTRIBUTE_CATEGORY
,
SD.VIEW_OPTIONS_CODE SUBSCRIPTION_LEVEL_CODE
,
SD.FIRST_PTY_ORG_ID SDCO_ID
,
SD.EFFECTIVE_FROM SDEFF_FROM
,
SD.EFFECTIVE_TO SDEFF_TO
FROM ZX_STATUS_B A
, ZX_SUBSCRIPTION_DETAILS SD
WHERE
A.TAX_REGIME_CODE = SD.TAX_REGIME_CODE
AND A.CONTENT_OWNER_ID = SD.PARENT_FIRST_PTY_ORG_ID
AND SD.VIEW_OPTIONS_CODE <> 'VFD'
ORDER BY SD.VIEW_OPTIONS_CODE