DBA Data[Home] [Help] [Dependency Information]

VIEW: MSD.MSD_ST_LEVEL_ORG_ASSCNS#

Object Details
Object Name: MSD_ST_LEVEL_ORG_ASSCNS#
Object Type: VIEW
Owner: MSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40) Yes
LEVEL_ID NUMBER
Yes
SR_LEVEL_PK VARCHAR2 (240) Yes
ORG_LEVEL_ID NUMBER
Yes
ORG_SR_LEVEL_PK VARCHAR2 (240) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_INSTANCE_CODE VARCHAR2 (3)
LEVEL_NAME VARCHAR2 (240)
LEVEL_VALUE VARCHAR2 (240)
ORG_LEVEL_NAME VARCHAR2 (240)
ORG_LEVEL_VALUE VARCHAR2 (240)
BATCH_ID NUMBER

ST_TRANSACTION_ID NUMBER

PROCESS_FLAG NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ERROR_TEXT VARCHAR2 (2000)
MESSAGE_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INSTANCE
,      LEVEL_ID
,      SR_LEVEL_PK
,      ORG_LEVEL_ID
,      ORG_SR_LEVEL_PK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_CODE
,      LEVEL_NAME
,      LEVEL_VALUE
,      ORG_LEVEL_NAME
,      ORG_LEVEL_VALUE
,      BATCH_ID
,      ST_TRANSACTION_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ERROR_TEXT
,      MESSAGE_ID
FROM MSD.MSD_ST_LEVEL_ORG_ASSCNS#;

Dependencies

[top of page]

MSD.MSD_ST_LEVEL_ORG_ASSCNS# references the following:

SchemaMSD
TableMSD_ST_LEVEL_ORG_ASSCNS
MSD.MSD_ST_LEVEL_ORG_ASSCNS# is referenced by following:

SchemaAPPS
SynonymMSD_ST_LEVEL_ORG_ASSCNS