ZX_SCO_STATUS_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_STATUS_ID TAX_STATUS_CODE CONTENT_OWNER_ID EFFECTIVE_FROM EFFECTIVE_TO TAX TAX_REGIME_CODE RULE_BASED_RATE_FLAG ALLOW_RATE_OVERRIDE_FLAG ALLOW_EXEMPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG DEFAULT_STATUS_FLAG DEFAULT_FLG_EFFECTIVE_FROM DEFAULT_FLG_EFFECTIVE_TO DEF_REC_SETTLEMENT_OPTION_CODE OBJECT_VERSION_NUMBER RECORD_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY TAX_STATUS_NAME SDCO_ID SDEFF_FROM SDEFF_TO

Query

SQL_Statement

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_APP_NAME, a.PROGRAM_NAME, 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, tl.TAX_STATUS_NAME, sd.first_pty_org_id SDCO_ID, sd.effective_from SDEFF_FROM, sd.effective_to SDEFF_TO from ZX_STATUS_B a, ZX_STATUS_TL tl, zx_subscription_details sd ,zx_subscription_options so where a.TAX_STATUS_ID = tl.TAX_STATUS_ID and tl.LANGUAGE = userenv('LANG') and a.tax_regime_code = sd.tax_regime_code and a.content_owner_id = sd.parent_first_pty_org_id and (sd.view_options_code in ('NONE', 'VFC') or (sd.view_options_code = 'VFR' and not exists ( select /*+ no unnest*/ 1 from zx_status_b b where b.tax_regime_code = a.tax_regime_code and b.tax = a.tax and b.tax_status_code = a.tax_status_code and b.content_owner_id = sd.first_pty_org_id ) ) ) and sd.subscription_option_id = so.subscription_option_id and so.enabled_flag = 'Y'