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

TABLE: MSD.MSD_ST_LEVEL_ASSOCIATIONS

Object Details
Object Name: MSD_ST_LEVEL_ASSOCIATIONS
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_ST_LEVEL_ASSOCIATIONS
Subobject Name:
Status: VALID


This staging table specifies the level value associations for a level with its parent in a Hierarchy. This is not stripped by the Demand Plan ID.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_ST_LEVEL_ASSOCIATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARENT_LEVEL_ID
ColumnLEVEL_ID
ColumnINSTANCE
MSD_ST_LEVEL_ASSOCIATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSR_LEVEL_PK
MSD_ST_LEVEL_ASSOCIATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINSTANCE
ColumnLEVEL_ID
ColumnSR_LEVEL_PK
ColumnPARENT_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40) Yes Source instance ID.
LEVEL_ID NUMBER
Yes Identifier for the level.
SR_LEVEL_PK VARCHAR2 (240) Yes Primary key for the level.
PARENT_LEVEL_ID NUMBER
Yes Parent level identifier.
SR_PARENT_LEVEL_PK VARCHAR2 (240) Yes Primary key for the parent level.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.
REQUEST_ID NUMBER

Concurrent who column.
PROGRAM_APPLICATION_ID NUMBER

Concurrent who column.
PROGRAM_ID NUMBER

Concurrent who column.
PROGRAM_UPDATE_DATE DATE

Concurrent who column.
LEVEL_NAME VARCHAR2 (30)
Level Name
PARENT_LEVEL_NAME VARCHAR2 (30)
Parent Level Name
SR_LEVEL_VALUE VARCHAR2 (240)
Source Level Value
SR_LEVEL_VALUE1 VARCHAR2 (240)
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code.
PROCESS_FLAG NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
DATA_SOURCE_TYPE VARCHAR2 (15)
This is an internal column. It is pouplate and used by Legacy Collection process.
ST_TRANSACTION_ID NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
BATCH_ID NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
ERROR_TEXT VARCHAR2 (2000)
This is an internal column. It is pouplate and used by Legacy Collection process.
MESSAGE_ID NUMBER

This is an internal column. It is pouplate and used by Legacy Collection process.
SR_PARENT_LEVEL_VALUE VARCHAR2 (240)
Source Parent LEvel Value
DP_ENABLED_FLAG NUMBER

This column is not in use. It was used to distinguish DP, SOP and EOL level values.
Query Text

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


SELECT INSTANCE
,      LEVEL_ID
,      SR_LEVEL_PK
,      PARENT_LEVEL_ID
,      SR_PARENT_LEVEL_PK
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LEVEL_NAME
,      PARENT_LEVEL_NAME
,      SR_LEVEL_VALUE
,      SR_LEVEL_VALUE1
,      SR_INSTANCE_CODE
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      ERROR_TEXT
,      MESSAGE_ID
,      SR_PARENT_LEVEL_VALUE
,      DP_ENABLED_FLAG
FROM MSD.MSD_ST_LEVEL_ASSOCIATIONS;

Dependencies

[top of page]

MSD.MSD_ST_LEVEL_ASSOCIATIONS does not reference any database object

MSD.MSD_ST_LEVEL_ASSOCIATIONS is referenced by following:

SchemaMSD
ViewMSD_ST_LEVEL_ASSOCIATIONS#