ZX_MCO_LV_STATUS

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

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

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

VIEW_OPTIONS_CODE

Query

SQL_Statement
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_APP_NAME, ZSB.PROGRAM_NAME, 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 ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99)) ORDER BY ZSD.VIEW_OPTIONS_CODE

SQL_Statement

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

ZSB.PROGRAM_NAME,

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 ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'

) OR (ZSD.FIRST_PTY_ORG_ID <> -99))

ORDER BY ZSD.VIEW_OPTIONS_CODE