[Home] [Help] [Dependency Information]
Object Name: | CSP_PL_PARAM_HISTORIES |
---|---|
Object Type: | TABLE |
Owner: | CSP |
Subobject Name: | |
Status: | VALID |
This table holds a copy of the planning parameters as they were saved at the time of creating the plans.The concurrent program 'Generate Plan Data for Warehouse Replenishment Planning' populates the table if parameter 'Save System Generated Plan' or 'Save Planner Generated Plan' is set to Yes.The same concurrent program will delete from this table all history data that is older than the number of days specified in parameter 'Purge Saved Plans Older Than (Days)'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_PL_PARAM_HISTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID HISTORY_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | VARCHAR2 | (240) | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | (38) | Item identifier | |
EXCESS_SERVICE_LEVEL | NUMBER | (38) | Excess service level | |
REPAIR_SERVICE_LEVEL | NUMBER | (38) | Repair service level | |
NEWBUY_SERVICE_LEVEL | NUMBER | (38) | Newbuy service level | |
EXCESS_EDQ_FACTOR | NUMBER | (38) | Excess EDQ factor | |
REPAIR_EDQ_FACTOR | NUMBER | (38) | Repair EDQ factor | |
NEWBUY_EDQ_FACTOR | NUMBER | (38) | Newbuy EDQ factor | |
EXCESS_EDQ_MULTIPLE | NUMBER | (38) | Excess EDQ multiple | |
REPAIR_EDQ_MULTIPLE | NUMBER | (38) | Repair EDQ multiple | |
NEWBUY_EDQ_MULTIPLE | NUMBER | (38) | Newbuy EDQ multiple | |
EXCESS_ROP | NUMBER | (38) | Excess reorder point | |
REPAIR_ROP | NUMBER | (38) | Repair reorder point | |
NEWBUY_ROP | NUMBER | (38) | Newbuy reorder point | |
EXCESS_SAFETY_STOCK | NUMBER | (38) | Excess safety stock | |
REPAIR_SAFETY_STOCK | NUMBER | (38) | Repair safety stock | |
NEWBUY_SAFETY_STOCK | NUMBER | (38) | Newbuy safety stock | |
EXCESS_EDQ | NUMBER | (38) | Excess EDQ | |
REPAIR_EDQ | NUMBER | (38) | Repair EDQ | |
NEWBUY_EDQ | NUMBER | (38) | Newbuy EDQ | |
EXCESS_LEAD_TIME | NUMBER | (38) | Excess lead time | |
REPAIR_LEAD_TIME | NUMBER | (38) | Repair lead time | |
NEWBUY_LEAD_TIME | NUMBER | (38) | Newbuy lead time | |
HISTORY_TYPE | VARCHAR2 | (30) | History type | |
HISTORY_DATE | DATE | History date | ||
CREATED_BY | NUMBER | (38) | Standard WHO column | |
CREATION_DATE | DATE | Standard WHO column | ||
LAST_UPDATED_BY | NUMBER | (38) | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Standard WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, EXCESS_SERVICE_LEVEL
, REPAIR_SERVICE_LEVEL
, NEWBUY_SERVICE_LEVEL
, EXCESS_EDQ_FACTOR
, REPAIR_EDQ_FACTOR
, NEWBUY_EDQ_FACTOR
, EXCESS_EDQ_MULTIPLE
, REPAIR_EDQ_MULTIPLE
, NEWBUY_EDQ_MULTIPLE
, EXCESS_ROP
, REPAIR_ROP
, NEWBUY_ROP
, EXCESS_SAFETY_STOCK
, REPAIR_SAFETY_STOCK
, NEWBUY_SAFETY_STOCK
, EXCESS_EDQ
, REPAIR_EDQ
, NEWBUY_EDQ
, EXCESS_LEAD_TIME
, REPAIR_LEAD_TIME
, NEWBUY_LEAD_TIME
, HISTORY_TYPE
, HISTORY_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM CSP.CSP_PL_PARAM_HISTORIES;
CSP.CSP_PL_PARAM_HISTORIES does not reference any database object
CSP.CSP_PL_PARAM_HISTORIES is referenced by following:
|
|
|