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

TABLE: MSD.MSD_ST_LEVEL_VALUES_LB

Object Details
Object Name: MSD_ST_LEVEL_VALUES_LB
Object Type: TABLE
Owner: MSD
Subobject Name:
Status: VALID


This is the staging table that temporarily stores the level values collected for liability analysis.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_ST_LEVEL_VALUES_LB_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPLAN_ID
ColumnLEVEL_ID
ColumnSR_LEVEL_PK
Columns
Name Datatype Length Mandatory Comments
LEVEL_ID NUMBER

Level identifier.
LEVEL_VALUE VARCHAR2 (240)
Value of the level.
PARENT_LEVEL_ID NUMBER

Parent level identifier.
PARENT_LEVEL_VALUE VARCHAR2 (240)
Value of the parent level.
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.
SR_LEVEL_PK VARCHAR2 (240)
Source primary key for the level value.
PROCESS_FLAG 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.
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code.
LEVEL_NAME VARCHAR2 (30)
Level Name.
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.
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.
LEVEL_VALUE_DESC VARCHAR2 (240)
Level Value Description.
SYSTEM_FLAG NUMBER

System Flag.
PLAN_ID NUMBER

ASCP Plan ID.
Query Text

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


SELECT LEVEL_ID
,      LEVEL_VALUE
,      PARENT_LEVEL_ID
,      PARENT_LEVEL_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_LEVEL_PK
,      PROCESS_FLAG
,      BATCH_ID
,      SR_INSTANCE_CODE
,      LEVEL_NAME
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      MESSAGE_ID
,      LEVEL_VALUE_DESC
,      SYSTEM_FLAG
,      PLAN_ID
FROM MSD.MSD_ST_LEVEL_VALUES_LB;

Dependencies

[top of page]

MSD.MSD_ST_LEVEL_VALUES_LB does not reference any database object

MSD.MSD_ST_LEVEL_VALUES_LB is referenced by following:

SchemaAPPS
SynonymMSD_ST_LEVEL_VALUES_LB