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

TABLE: MRP.MRP_LOAD_SELECTIONS

Object Details
Object Name: MRP_LOAD_SELECTIONS
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_LOAD_SELECTIONS
Subobject Name:
Status: VALID


MRP_LOAD_SELECTIONS is a table that stores Forecast and Master
Schedule Source Lists. Source Selection Lists are used to define the
input Forecasts or Master Schedules for the Forecast or Master
Schedule Loads.
This table is populated by the Define Source Lists form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_LOAD_SELECTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSELECTION_LIST_NAME
ColumnSELECTION_LIST_TYPE
Columns
Name Datatype Length Mandatory Comments
SELECTION_LIST_NAME VARCHAR2 (10) Yes Selection list name
ORGANIZATION_ID NUMBER
Yes Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
DESCRIPTION VARCHAR2 (50)
Selection list description
SELECTION_LIST_TYPE NUMBER (22) Yes Selection list type
Query Text

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


SELECT SELECTION_LIST_NAME
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      SELECTION_LIST_TYPE
FROM MRP.MRP_LOAD_SELECTIONS;

Dependencies

[top of page]

MRP.MRP_LOAD_SELECTIONS does not reference any database object

MRP.MRP_LOAD_SELECTIONS is referenced by following:

SchemaMRP
ViewMRP_LOAD_SELECTIONS#