ZX_MCO_EO_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 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 CONTENT_OWNER_NAME UPDATE_ACCESS DUPLICATE_ACCESS

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

CONTENT_OWNER_NAME

UPDATE_ACCESS

DUPLICATE_ACCESS

Query

SQL_Statement
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_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, 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

SQL_Statement

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

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