[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_PNDM_PLN_LTC |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_PNDM_PLN_LTC |
Subobject Name: | |
Status: | VALID |
This is the Plan level table in the Plan dimension. This stores all the Plans.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_MRP_PNDM_PLN_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PLAN_NAME_PK_KEY |
EDW_MRP_PNDM_PLN_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PLAN_NAME_PK
PLAN_NAME_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_NAME_PK | VARCHAR2 | (120) | Unique identifier | |
PLAN_NAME_PK_KEY | NUMBER | System generated unique identifier | ||
COMPLETION_DATE | DATE | Date/time the Plan was completed | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
DESCRIPTION | VARCHAR2 | (240) | Plan description | |
INCLUDE_PO_FLAG | VARCHAR2 | (20) | Flag to indicate if Purchase Orders were included in the plan | |
INCLUDE_WIP_FLAG | VARCHAR2 | (20) | Flag to indicate if Work in Process inventories were included in the plan | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance code refering to the source application | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
NAME | VARCHAR2 | (2000) | Plan alternate name | |
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_NAME | VARCHAR2 | (40) | Plan name | |
PLAN_NAME_DP | VARCHAR2 | (240) | Unique Plan name | |
PLAN_RESERVE_FLAG | VARCHAR2 | (20) | Flag to indicate if supply was reserved against demand | |
PLAN_SAFETY_STOCK | VARCHAR2 | (20) | Flag to indicate if safety stock was calculated for each item during the execution of the plan | |
PLAN_TYPE | VARCHAR2 | (40) | Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan. | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_NAME_PK
, PLAN_NAME_PK_KEY
, COMPLETION_DATE
, CREATION_DATE
, DESCRIPTION
, INCLUDE_PO_FLAG
, INCLUDE_WIP_FLAG
, INSTANCE_CODE
, LAST_UPDATE_DATE
, NAME
, PLAN_CUTOFF_DATE
, PLAN_NAME
, PLAN_NAME_DP
, PLAN_RESERVE_FLAG
, PLAN_SAFETY_STOCK
, PLAN_TYPE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM ISC.EDW_MRP_PNDM_PLN_LTC;
ISC.EDW_MRP_PNDM_PLN_LTC does not reference any database object
ISC.EDW_MRP_PNDM_PLN_LTC is referenced by following:
|
|
|