[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_PLAN_M |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_PLAN_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Plan dimension. It contains records for the lowest level of the Plan dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_MRP_PLAN_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PLAN_PLAN_NAME_PK
PLAN_PLAN_NAME_PK_KEY |
EDW_MRP_PLAN_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PLAN_PLAN_NAME_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_PLAN_NAME_PK | VARCHAR2 | (120) | Unique identifier | |
PLAN_PLAN_NAME_PK_KEY | NUMBER | Yes | System generated unique identifier | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
PLAN_COMPLETION_DATE | DATE | Date/time the Plan was completed | ||
PLAN_DESCRIPTION | VARCHAR2 | (240) | Plan description | |
PLAN_INCLUDE_PO_FLAG | VARCHAR2 | (20) | Flag to indicate if Purchase Orders were included in the plan | |
PLAN_INCLUDE_WIP_FLAG | VARCHAR2 | (20) | Flag to indicate if Work in Process inventories were included in the plan | |
PLAN_INSTANCE_CODE | VARCHAR2 | (40) | Instance code refering to the source application | |
PLAN_NAME | VARCHAR2 | (80) | Alternate Plan name | |
PLAN_PLAN_CUTOFF_DATE | DATE | Cutoff date of the plan. The cutoff date is used to determine the end date when selecting entries into the plan (for example, when loading forecast entries into the plan, end date = cutoff date + carry forward days). | ||
PLAN_PLAN_NAME | VARCHAR2 | (40) | Plan name | |
PLAN_PLAN_NAME_DP | VARCHAR2 | (240) | Unique Plan name | |
PLAN_PLAN_RESERVE_FLAG | VARCHAR2 | (20) | Flag to indicate if supply was reserved against demand | |
PLAN_PLAN_SAFETY_STOCK | VARCHAR2 | (20) | Flag to indicate if safety stock was calculated for each item during the execution of the plan | |
PLAN_PLAN_TYPE | VARCHAR2 | (40) | Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan. | |
PLAN_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User attribute | |
PLAN_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User attribute | |
PLAN_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User attribute | |
PLAN_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User attribute | |
PLAN_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_PLAN_NAME_PK
, PLAN_PLAN_NAME_PK_KEY
, CREATION_DATE
, LAST_UPDATE_DATE
, PLAN_COMPLETION_DATE
, PLAN_DESCRIPTION
, PLAN_INCLUDE_PO_FLAG
, PLAN_INCLUDE_WIP_FLAG
, PLAN_INSTANCE_CODE
, PLAN_NAME
, PLAN_PLAN_CUTOFF_DATE
, PLAN_PLAN_NAME
, PLAN_PLAN_NAME_DP
, PLAN_PLAN_RESERVE_FLAG
, PLAN_PLAN_SAFETY_STOCK
, PLAN_PLAN_TYPE
, PLAN_USER_ATTRIBUTE1
, PLAN_USER_ATTRIBUTE2
, PLAN_USER_ATTRIBUTE3
, PLAN_USER_ATTRIBUTE4
, PLAN_USER_ATTRIBUTE5
FROM ISC.EDW_MRP_PLAN_M;
ISC.EDW_MRP_PLAN_M does not reference any database object
ISC.EDW_MRP_PLAN_M is referenced by following:
|
|
|