[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_PNDM_PLN_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_PNDM_PLN_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Plan level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_MRP_PNDM_PLN_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PLAN_NAME_PK |
EDW_MRP_PNDM_PLN_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_NAME_PK | VARCHAR2 | (120) | Unique identifier | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
COMPLETION_DATE | DATE | Date/time the Plan was completed | ||
DESCRIPTION | VARCHAR2 | (240) | Plan description | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
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 | VARCHAR2 | (40) | Instance code refering to the source application | |
NAME | VARCHAR2 | (2000) | Alternate Plan name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
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. | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | ROWID | (10) | Row Id | |
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
, COLLECTION_STATUS
, COMPLETION_DATE
, DESCRIPTION
, ERROR_CODE
, INCLUDE_PO_FLAG
, INCLUDE_WIP_FLAG
, INSTANCE
, NAME
, OPERATION_CODE
, PLAN_CUTOFF_DATE
, PLAN_NAME
, PLAN_NAME_DP
, PLAN_RESERVE_FLAG
, PLAN_SAFETY_STOCK
, PLAN_TYPE
, REQUEST_ID
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM ISC.EDW_MRP_PNDM_PLN_LSTG;
ISC.EDW_MRP_PNDM_PLN_LSTG does not reference any database object
ISC.EDW_MRP_PNDM_PLN_LSTG is referenced by following:
|
|
|