[Home] [Help] [Dependency Information]
Object Name: | MSC_SUP_DEM_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_SUP_DEM_HISTORY |
Subobject Name: | |
Status: | VALID |
This table contains historical information on inserts/updates and deletes done on data in
Oracle Collaborative planning. This table is populated by a trigger which fires after a DML
operation on MSC_SUP_DEM_ENTRIES, the primary transaction table in Oracle
Collaborative planning.
Data in this table is used to support the auditing functionality in Oracle Collaborative planning.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_SUP_DEM_HISTORY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PUBLISHER_ORDER_TYPE ITEM_NAME NEW_SCHEDULE_DATE_NEW |
MSC_SUP_DEM_HISTORY_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PUBLISHER_ORDER_TYPE PUBLISHER_NAME PUBLISHER_SITE_NAME ITEM_NAME SUPPLIER_NAME SUPPLIER_SITE_NAME ORDER_NUMBER LINE_NUMBER RELEASE_NUMBER |
MSC_SUP_DEM_HISTORY_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PUBLISHER_ORDER_TYPE ITEM_NAME DESIGNATOR_NEW VERSION_NEW CUSTOMER_NAME CUSTOMER_SITE_NAME SUPPLIER_NAME SUPPLIER_SITE_NAME |
MSC_SUP_DEM_HISTORY_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
KEY_DATE_NEW
PUBLISHER_ORDER_TYPE PLAN_ID |
MSC_SUP_DEM_HISTORY_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
KEY_DATE_OLD
PUBLISHER_ORDER_TYPE PLAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HISTORY_ID | NUMBER | History identifier | ||
PLAN_ID | NUMBER | Plan identifier | ||
TRANSACTION_ID | NUMBER | Transaction identifier | ||
PUBLISHER_NAME | VARCHAR2 | (255) | Publisher name | |
PUBLISHER_SITE_NAME | VARCHAR2 | (40) | Publisher site name | |
PUBLISHER_ORDER_TYPE | NUMBER | Publisher order type | ||
PUBLISHER_ORDER_TYPE_DESC | VARCHAR2 | (80) | Publisher order type description | |
PUBLISHER_ITEM_NAME | VARCHAR2 | (250) | Publisher item name | |
PUB_ITEM_DESCRIPTION | VARCHAR2 | (250) | Publisher item description | |
TRADING_PARTNER_ITEM_NAME | VARCHAR2 | (250) | Trading partner item name | |
TP_ITEM_DESCRIPTION | VARCHAR2 | (250) | Trading partner item description | |
CUSTOMER_NAME | VARCHAR2 | (255) | Customer name | |
CUSTOMER_SITE_NAME | VARCHAR2 | (40) | Customer site name | |
SUPPLIER_NAME | VARCHAR2 | (255) | Supplier name | |
SUPPLIER_SITE_NAME | VARCHAR2 | (40) | Supplier site name | |
ORDER_NUMBER | VARCHAR2 | (240) | Order number | |
LINE_NUMBER | VARCHAR2 | (25) | Line number | |
RELEASE_NUMBER | VARCHAR2 | (25) | Release number | |
END_ORDER_NUMBER | VARCHAR2 | (240) | Pegged order number | |
END_ORDER_LINE_NUMBER | VARCHAR2 | (25) | Pegged order line number | |
END_ORDER_REL_NUMBER | VARCHAR2 | (25) | Pegged order release number | |
DESIGNATOR_OLD | VARCHAR2 | (100) | Old designator | |
DESIGNATOR_NEW | VARCHAR2 | (100) | New designator | |
VERSION_OLD | VARCHAR2 | (240) | Old version | |
VERSION_NEW | VARCHAR2 | (240) | New version | |
QUANTITY_OLD | NUMBER | Old quantity | ||
QUANTITY_NEW | NUMBER | New quantity | ||
COMMENTS_OLD | VARCHAR2 | (1000) | Old comments | |
COMMENTS_NEW | VARCHAR2 | (1000) | New comments | |
KEY_DATE_OLD | DATE | Old key date | ||
KEY_DATE_NEW | DATE | New key date | ||
SHIP_DATE_OLD | DATE | Old ship date | ||
SHIP_DATE_NEW | DATE | New ship date | ||
RECEIPT_DATE_OLD | DATE | Old receipt date | ||
RECEIPT_DATE_NEW | DATE | New receipt date | ||
NEW_SCHEDULE_DATE_OLD | DATE | Old new schedule date | ||
NEW_SCHEDULE_DATE_NEW | DATE | New new schedule date | ||
NEW_ORDER_PLACEMENT_DATE_OLD | DATE | Old new order placement date | ||
NEW_ORDER_PLACEMENT_DATE_NEW | DATE | New new order placement date | ||
ORIGINAL_PROMISED_DATE_OLD | DATE | Old original promised date | ||
ORIGINAL_PROMISED_DATE_NEW | DATE | New original promised date | ||
REQUEST_DATE_OLD | DATE | Old request date | ||
REQUEST_DATE_NEW | DATE | New request date | ||
PLANNED_WIP_START_DATE_OLD | DATE | Old planned WIP start date | ||
PLANNED_WIP_START_DATE_NEW | DATE | New planned WIP start date | ||
PLANNED_WIP_END_DATE_OLD | DATE | Old planned WIP end date | ||
PLANNED_WIP_END_DATE_NEW | DATE | New planned WIP end date | ||
WIP_START_DATE_OLD | DATE | Old WIP start date | ||
WIP_START_DATE_NEW | DATE | New WIP start date | ||
WIP_END_DATE_OLD | DATE | Old WIP end date | ||
WIP_END_DATE_NEW | DATE | New WIP end date | ||
LAST_REFRESH_NUMBER_OLD | NUMBER | Old last refresh number | ||
LAST_REFRESH_NUMBER_NEW | NUMBER | New last refresh number | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
DMLTYPE | VARCHAR2 | (1) | DML type | |
ITEM_NAME | VARCHAR2 | (250) | Item name | |
OWNER_ITEM_NAME | VARCHAR2 | (250) | Owner item name | |
CUSTOMER_ITEM_NAME | VARCHAR2 | (250) | Customer item name | |
SUPPLIER_ITEM_NAME | VARCHAR2 | (250) | Supplier item name | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
OWNER_ITEM_DESCRIPTION | VARCHAR2 | (240) | Owner item description | |
SUPPLIER_ITEM_DESCRIPTION | VARCHAR2 | (240) | Supplier item description | |
CUSTOMER_ITEM_DESCRIPTION | VARCHAR2 | (240) | Customer item description | |
BUCKET_TYPE_NEW | NUMBER | New value for bucket type | ||
BUCKET_TYPE_OLD | NUMBER | Old value for bucket type | ||
USE_FOR_COMPARISON | NUMBER | Internal flag to identify records for comparison |
Cut, paste (and edit) the following text to query this object:
SELECT HISTORY_ID
, PLAN_ID
, TRANSACTION_ID
, PUBLISHER_NAME
, PUBLISHER_SITE_NAME
, PUBLISHER_ORDER_TYPE
, PUBLISHER_ORDER_TYPE_DESC
, PUBLISHER_ITEM_NAME
, PUB_ITEM_DESCRIPTION
, TRADING_PARTNER_ITEM_NAME
, TP_ITEM_DESCRIPTION
, CUSTOMER_NAME
, CUSTOMER_SITE_NAME
, SUPPLIER_NAME
, SUPPLIER_SITE_NAME
, ORDER_NUMBER
, LINE_NUMBER
, RELEASE_NUMBER
, END_ORDER_NUMBER
, END_ORDER_LINE_NUMBER
, END_ORDER_REL_NUMBER
, DESIGNATOR_OLD
, DESIGNATOR_NEW
, VERSION_OLD
, VERSION_NEW
, QUANTITY_OLD
, QUANTITY_NEW
, COMMENTS_OLD
, COMMENTS_NEW
, KEY_DATE_OLD
, KEY_DATE_NEW
, SHIP_DATE_OLD
, SHIP_DATE_NEW
, RECEIPT_DATE_OLD
, RECEIPT_DATE_NEW
, NEW_SCHEDULE_DATE_OLD
, NEW_SCHEDULE_DATE_NEW
, NEW_ORDER_PLACEMENT_DATE_OLD
, NEW_ORDER_PLACEMENT_DATE_NEW
, ORIGINAL_PROMISED_DATE_OLD
, ORIGINAL_PROMISED_DATE_NEW
, REQUEST_DATE_OLD
, REQUEST_DATE_NEW
, PLANNED_WIP_START_DATE_OLD
, PLANNED_WIP_START_DATE_NEW
, PLANNED_WIP_END_DATE_OLD
, PLANNED_WIP_END_DATE_NEW
, WIP_START_DATE_OLD
, WIP_START_DATE_NEW
, WIP_END_DATE_OLD
, WIP_END_DATE_NEW
, LAST_REFRESH_NUMBER_OLD
, LAST_REFRESH_NUMBER_NEW
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DMLTYPE
, ITEM_NAME
, OWNER_ITEM_NAME
, CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME
, ITEM_DESCRIPTION
, OWNER_ITEM_DESCRIPTION
, SUPPLIER_ITEM_DESCRIPTION
, CUSTOMER_ITEM_DESCRIPTION
, BUCKET_TYPE_NEW
, BUCKET_TYPE_OLD
, USE_FOR_COMPARISON
FROM MSC.MSC_SUP_DEM_HISTORY;
MSC.MSC_SUP_DEM_HISTORY does not reference any database object
MSC.MSC_SUP_DEM_HISTORY is referenced by following:
|
|
|