eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MSC.MSC_SUP_DEM_HISTORY

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

MSC.MSC_SUP_DEM_HISTORY does not reference any database object

MSC.MSC_SUP_DEM_HISTORY is referenced by following:

APPS: MSC_SUP_DEM_HISTORY