[Home] [Help] [Dependency Information]
Object Name: | CSP_PLAN_HISTORIES |
---|---|
Object Type: | TABLE |
Owner: | CSP |
Subobject Name: | |
Status: | VALID |
This table stores historical plan data.
It is possible to store 2 types of historical data at the time of running the concurrent program for generating plan data. Plan data can be stored in the history table right before and right after new data is generated. Data stored just before will include all the planners changes to the system generated plan. Data stored just after new plan data is generated will be the system generated plan.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_PLAN_HISTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID HISTORY_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_DETAIL_TYPE | VARCHAR2 | (30) | Type of plan data | |
ORGANIZATION_ID | NUMBER | (38) | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | (38) | Inventory item identifier | |
PARENT_TYPE | VARCHAR2 | (30) | Type of parent | |
PLAN_DATE | DATE | Plan date | ||
SOURCE_NUMBER | VARCHAR2 | (30) | Source document number | |
SOURCE_ORGANIZATION_ID | NUMBER | (38) | Source organization 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 | |
RELATED_ITEM_ID | NUMBER | (38) | Related item identifier | |
AVAILABLE_QUANTITY | NUMBER | (38) | Available quantity | |
EXCESS_QUANTITY | NUMBER | (38) | Excess quantity | |
ONHAND_QUANTITY | NUMBER | (38) | Onhand quantity | |
QUANTITY | NUMBER | (38) | Quantity | |
SECURITY_GROUP_ID | NUMBER | (38) | Security group identifier | |
PLAN_DETAIL_ID | NUMBER | (38) | Plan detail identifier | |
PERIOD_SIZE | NUMBER | (38) | Period size in days | |
FORECAST_PERIODS | NUMBER | (38) | Number of forecast periods | |
HISTORY_TYPE | VARCHAR2 | (30) | Plan history type | |
HISTORY_DATE | DATE | Plan history date |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_DETAIL_TYPE
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PARENT_TYPE
, PLAN_DATE
, SOURCE_NUMBER
, SOURCE_ORGANIZATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RELATED_ITEM_ID
, AVAILABLE_QUANTITY
, EXCESS_QUANTITY
, ONHAND_QUANTITY
, QUANTITY
, SECURITY_GROUP_ID
, PLAN_DETAIL_ID
, PERIOD_SIZE
, FORECAST_PERIODS
, HISTORY_TYPE
, HISTORY_DATE
FROM CSP.CSP_PLAN_HISTORIES;
CSP.CSP_PLAN_HISTORIES does not reference any database object
CSP.CSP_PLAN_HISTORIES is referenced by following:
|
|
|