[Home] [Help] [Dependency Information]
Object Name: | CSP_ITEM_PL_PARAMS |
---|---|
Object Type: | TABLE |
Owner: | CSP |
Subobject Name: | |
Status: | VALID |
This table holds the planning parameters for an item if the planning parameter for the item is different than the planning parameter for the Warehouse.The WRP planning page inserts records to this table when planning parameters are changed and saved.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_ITEM_PL_PARAMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ITEM_PL_PARAMS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_PL_PARAMS_ID | NUMBER | (38) | Unique item planning parameter id | |
ORGANIZATION_ID | NUMBER | (38) | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | (38) | Inventory item identifier | |
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 | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_PL_PARAMS_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, 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
FROM CSP.CSP_ITEM_PL_PARAMS;
CSP.CSP_ITEM_PL_PARAMS does not reference any database object
CSP.CSP_ITEM_PL_PARAMS is referenced by following:
|
|
|