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_ENTRIES

Object Details

Object Name:	MSC_SUP_DEM_ENTRIES
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_SUP_DEM_ENTRIES
Subobject Name:
Status:	VALID

This is the primary transaction table for Oracle Collaborative planning.
All data seen in the vertical view, horizontal view and VMI screens in Oracle Collaborative planning
are based on this table.
This table is populated by any of the following ways:
1. Collection programs from Oracle ERP Systems.
2. Flat file/XML loads of transaction data loaded into Oracle Advanced Supply Chain Planning.
3. Flat file/XML loads of transaction data loaded directly into Oracle Collaborative Planning.
4. Collaborative planning user interface for manual order entry.
5. Publish programs to move data from Oracle Advanced Supply Chain Planning and Oracle
Demand Planning.

All transaction data in MSC_SUP_DEM_ENTRIES must have an order type corresponding
to the values in the lookup MSC_X_ORDER_TYPE.
VMI replenishments are generated by comparing the on hand and purchasing data in this table
to the order quantities in MSC_ITEM_SUPPLIER table.
Supply chain event management exceptions are generated based on data in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_SUP_DEM_ENTRIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID PLAN_ID
MSC_SUP_DEM_ENTRIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID PUBLISHER_ORDER_TYPE SUPPLIER_ID SUPPLIER_SITE_ID INVENTORY_ITEM_ID PUBLISHER_ID PUBLISHER_SITE_ID
MSC_SUP_DEM_ENTRIES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PUBLISHER_ORDER_TYPE CREATION_DATE
MSC_SUP_DEM_ENTRIES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REF_HEADER_ID PUBLISHER_ORDER_TYPE
MSC_SUP_DEM_ENTRIES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_DELIVERY_ID
MSC_SUP_DEM_ENTRIES_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BASE_ITEM_ID
MSC_SUP_DEM_ENTRIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID PUBLISHER_ORDER_TYPE CUSTOMER_ID CUSTOMER_SITE_ID INVENTORY_ITEM_ID PUBLISHER_ID PUBLISHER_SITE_ID
MSC_SUP_DEM_ENTRIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_NAME
MSC_SUP_DEM_ENTRIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_ITEM_NAME
MSC_SUP_DEM_ENTRIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ITEM_NAME
MSC_SUP_DEM_ENTRIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KEY_DATE PLAN_ID PUBLISHER_ORDER_TYPE
MSC_SUP_DEM_ENTRIES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_REFRESH_NUMBER
MSC_SUP_DEM_ENTRIES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_NUMBER
MSC_SUP_DEM_ENTRIES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_ORDER_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction identifier
PLAN_ID	NUMBER		Yes	Plan identifier
SR_INSTANCE_ID	NUMBER			Source application instance identifier
PUBLISHER_ID	NUMBER		Yes	Publisher identifier
PUBLISHER_SITE_ID	NUMBER		Yes	Publisher site identifier
PUBLISHER_NAME	VARCHAR2	(255)		Publisher name
PUBLISHER_SITE_NAME	VARCHAR2	(40)		Publisher site name
NEW_SCHEDULE_DATE	DATE			New schedule date
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
QUANTITY	NUMBER		Yes	Quantity
TP_QUANTITY	NUMBER			Trading partner quantity
COMMENTS	VARCHAR2	(1000)		Comments
PUBLISHER_ORDER_TYPE	NUMBER		Yes	Publisher order type
SUPPLIER_ID	NUMBER			Supplier identifier
SUPPLIER_NAME	VARCHAR2	(255)		Supplier name
SUPPLIER_SITE_ID	NUMBER			Supplier site identifier
SUPPLIER_SITE_NAME	VARCHAR2	(40)		Supplier site name
CUSTOMER_ID	NUMBER			Customer identifier
CUSTOMER_NAME	VARCHAR2	(255)		Customer name
CUSTOMER_SITE_ID	NUMBER			Customer site identifier
CUSTOMER_SITE_NAME	VARCHAR2	(40)		Customer site name
LINE_CODE	VARCHAR2	(30)		Line code
BUCKET_TYPE	NUMBER			Bucket type
ORDER_NUMBER	VARCHAR2	(240)		Order number
END_ORDER_NUMBER	VARCHAR2	(240)		Pegged order number
NEW_DOCK_DATE	DATE			New dock date
POSTING_PARTY_ID	NUMBER			Posting party identifier
NEW_SHIP_DATE	DATE			New ship date
NEW_ORDER_PLACEMENT_DATE	DATE			New order placement date
RELEASE_NUMBER	VARCHAR2	(25)		Release number
LINE_NUMBER	VARCHAR2	(25)		Line number
END_ORDER_REL_NUMBER	VARCHAR2	(25)		Pegged order release number
END_ORDER_LINE_NUMBER	VARCHAR2	(25)		Pegged order line number
PUBLISHER_ADDRESS_ID	NUMBER			Publisher address identifier
CARRIER_CODE	VARCHAR2	(30)		Carrier code
VEHICLE_NUMBER	VARCHAR2	(30)		Vehicle number
CONTAINER_TYPE	VARCHAR2	(20)		Container type
CONTAINER_QTY	NUMBER			Container quantity
TRACKING_NUMBER	VARCHAR2	(240)		Tracking number
VERSION	VARCHAR2	(240)		Version
END_ORDER_TYPE	NUMBER			End order type
END_ORDER_PUBLISHER_ID	NUMBER			End order publisher identifier
SHIP_TO_ADDRESS	VARCHAR2	(240)		Ship to address
SHIP_FROM_PARTY_ID	NUMBER			Ship from party identifier
SHIP_TO_PARTY_ID	NUMBER			Ship to party identifier
SHIP_TO_PARTY_SITE_ID	NUMBER			Ship to party site identifier
SHIP_TO_PARTY_ADDRESS_ID	NUMBER			Ship to party address identifier
SHIP_TO_PARTY_NAME	VARCHAR2	(255)		Ship to party name
SHIP_TO_PARTY_SITE_NAME	VARCHAR2	(40)		Ship to party site name
SHIP_FROM_PARTY_ADDRESS_ID	NUMBER			Ship from party address identifier
SHIP_FROM_PARTY_SITE_ID	NUMBER			Ship from party site identifier
SHIP_FROM_PARTY_NAME	VARCHAR2	(255)		Ship from party name
SHIP_FROM_PARTY_SITE_NAME	VARCHAR2	(40)		Ship from party site name
OWNING_SITE_ID	NUMBER			Owning site identifier
OWNING_SITE_NAME	VARCHAR2	(40)		Owning site name
END_ORDER_PUBLISHER_SITE_ID	NUMBER			End order publisher site identifier
END_ORDER_PUBLISHER_SITE_NAME	VARCHAR2	(40)		End order publisher site name
END_ORDER_PUBLISHER_NAME	VARCHAR2	(255)		End order publisher name
PUBLISHER_ITEM_NAME	VARCHAR2	(250)		Publisher item name
TRADING_PARTNER_ITEM_NAME	VARCHAR2	(250)		Trading partner item name
PUB_ITEM_DESCRIPTIION	VARCHAR2	(240)		Publisher item description
TP_ITEM_DESCRIPTION	VARCHAR2	(240)		Trading partner item description
PUBLISHER_ORDER_TYPE_DESC	VARCHAR2	(80)		Publisher order type description
TP_ORDER_TYPE_DESC	VARCHAR2	(80)		Trading partner order type description
DESIGNATOR	VARCHAR2	(100)		Designator
CONTEXT	VARCHAR2	(30)		Context
UNIT_NUMBER	VARCHAR2	(30)		Unit number
SHIP_METHOD	VARCHAR2	(30)		Ship method
PROJECT_NUMBER	VARCHAR2	(30)		Project number
TASK_NUMBER	VARCHAR2	(30)		Task number
PLANNING_GROUP	VARCHAR2	(30)		Planning group
SHIP_FROM_ADDRESS	VARCHAR2	(240)		Ship from address
PUBLISHER_ADDRESS	VARCHAR2	(240)		Publisher address
CUSTOMER_ADDRESS	VARCHAR2	(240)		Customer address
SUPPLIER_ADDRESS	VARCHAR2	(240)		Supplier address
AVERAGE_ANNUAL_DEMAND	NUMBER			Average annual demand
BILL_OF_LADING_NUMBER	VARCHAR2	(30)		Bill of lading number
BUCKET_TYPE_DESC	VARCHAR2	(30)		Bucket type description
SERIAL_NUMBER	VARCHAR2	(255)		Serial number
RELEASE_STATUS	NUMBER			Release status
INVENTORY_STATUS	VARCHAR2	(20)		Inventory status
WIP_END_DATE	DATE			WIP end date
WIP_START_DATE	DATE			WIP start date
PROMISE_SHIP_DATE	DATE			Promise ship date
NEW_SCHEDULE_END_DATE	DATE			New schedule end date
POSTING_PARTY_NAME	VARCHAR2	(255)		Posting party name
PUB_ITEM_DESCRIPTION	VARCHAR2	(240)		Publisher item description
UOM_CODE	VARCHAR2	(3)		Unit of measure code
TP_UOM_CODE	VARCHAR2	(3)		Trading partner unit of measure code
PLANNER_CODE	VARCHAR2	(10)		Planner code
LAST_REFRESH_NUMBER	NUMBER			Last refresh number
ATTACHMENT_URL	VARCHAR2	(240)		Attachement URL
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
REQUEST_ID	NUMBER			Concurrent Who Column
PROGRAM_ID	NUMBER			Concurrent Who Column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who Column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
KEY_DATE	DATE			Key date
SHIP_DATE	DATE			Ship date
RECEIPT_DATE	DATE			Receipt date
ORIGINAL_PROMISED_DATE	DATE			Original promised date
REQUEST_DATE	DATE			Request date
PRIMARY_UOM	VARCHAR2	(3)		Primary unit of measure
PRIMARY_QUANTITY	NUMBER			Primary quantity
REF_HEADER_ID	NUMBER			Reference header identifier
REF_LINE_ID	NUMBER			Reference line identifier
CATEGORY_NAME	VARCHAR2	(200)		Category name
PUBLISHER_ORG_ID	NUMBER			Obsolete column, used for backward compatibility
SUBSCRIBER_ORG_ID	NUMBER			Obsolete column, used for backward compatibility
ASSEMBLY_ITEM_ID	NUMBER			Column used for backward compatibilty with older releases
CATEGORY_ID	NUMBER			Column used for backward compatibilty with older releases
START_DATE	DATE			Column used for backward compatibilty with older releases
END_DATE	NUMBER			Column used for backward compatibilty with older releases
PRODUCTION_SEQUENCE	VARCHAR2	(30)		Column used for backward compatibilty with older releases
SEQ_PLAN_COMPLETION_FLAG	VARCHAR2	(1)		Column used for backward compatibilty with older releases
INPUT_PLAN_ID	NUMBER			Column used for backward compatibilty with older releases
END_ASSEMBLY_ITEM_NAME	VARCHAR2	(250)		Column used for backward compatibilty with older releases
SUBSCRIBER_ADDRESS_ID	NUMBER			Column used for backward compatibilty with older releases
TP_ORDER_TYPE	NUMBER			Trading partner order type
PROCESSED_FLAG	VARCHAR2	(1)		Processed flag
PLANNED_WIP_START_DATE	DATE			Planned WIP start date
PLANNED_WIP_END_DATE	DATE			Planned WIP end date
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory code
CUSTOMER_ITEM_NAME	VARCHAR2	(250)		Customer item name
SUPPLIER_ITEM_NAME	VARCHAR2	(250)		Supplier item name
OWNER_ITEM_NAME	VARCHAR2	(250)		Owner item name
ITEM_NAME	VARCHAR2	(250)		Item name
QUANTITY_IN_PROCESS	NUMBER			Quantity in process
IMPLEMENTED_QUANTITY	NUMBER			Implemented quantity
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
CUSTOMER_ITEM_DESCRIPTION	VARCHAR2	(240)		Customer item description
SUPPLIER_ITEM_DESCRIPTION	VARCHAR2	(240)		Supplier item description
OWNER_ITEM_DESCRIPTION	VARCHAR2	(240)		Owner item description
TOTAL_QUANTITY	NUMBER			Total quantity
TOTAL_PRIMARY_QUANTITY	NUMBER			Total primary quantity
TOTAL_TP_QUANTITY	NUMBER			Total trading partner quantity
NUMBER1	NUMBER			Number1
VMI_FLAG	NUMBER			VMI flag
ACK_FLAG	VARCHAR2	(1)		Flag to identifier sales order is from PO Acknowledgement
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)		Acceptance Required Flag for PO transaction
DOCUMENT_NUMBER	VARCHAR2	(240)		Document Number
RESPONSE_NUMBER	VARCHAR2	(240)		Response Number
NEED_BY_DATE	DATE			Need by date
PROMISED_DATE	DATE			Promised date
BASE_ITEM_ID	NUMBER			Item identifier of model for configured items
BASE_ITEM_NAME	VARCHAR2	(250)		Model item name for configured items
SHIPPING_CONTROL	VARCHAR2	(30)		Flag to show whether buyer or seller controls logistics
LINK_TRANS_ID	NUMBER			Internal column
INTERNAL_FLAG	NUMBER			Flag to identify internal requisitions/sales orders
SOURCE_DELIVERY_ID	NUMBER			Delivery Identifier
SR_DELIVERY_STATUS_CODE	VARCHAR2	(2)		Delivery Status Code
SHIPPING_CONTROL_CODE	NUMBER			Shipping control code
END_ORDER_TYPE_DESC	VARCHAR2	(80)		End Order Type Description
DEMAND_CLASS	VARCHAR2	(30)		Demand Class

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      PUBLISHER_ID
,      PUBLISHER_SITE_ID
,      PUBLISHER_NAME
,      PUBLISHER_SITE_NAME
,      NEW_SCHEDULE_DATE
,      INVENTORY_ITEM_ID
,      QUANTITY
,      TP_QUANTITY
,      COMMENTS
,      PUBLISHER_ORDER_TYPE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_SITE_NAME
,      LINE_CODE
,      BUCKET_TYPE
,      ORDER_NUMBER
,      END_ORDER_NUMBER
,      NEW_DOCK_DATE
,      POSTING_PARTY_ID
,      NEW_SHIP_DATE
,      NEW_ORDER_PLACEMENT_DATE
,      RELEASE_NUMBER
,      LINE_NUMBER
,      END_ORDER_REL_NUMBER
,      END_ORDER_LINE_NUMBER
,      PUBLISHER_ADDRESS_ID
,      CARRIER_CODE
,      VEHICLE_NUMBER
,      CONTAINER_TYPE
,      CONTAINER_QTY
,      TRACKING_NUMBER
,      VERSION
,      END_ORDER_TYPE
,      END_ORDER_PUBLISHER_ID
,      SHIP_TO_ADDRESS
,      SHIP_FROM_PARTY_ID
,      SHIP_TO_PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_PARTY_ADDRESS_ID
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_PARTY_SITE_NAME
,      SHIP_FROM_PARTY_ADDRESS_ID
,      SHIP_FROM_PARTY_SITE_ID
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_PARTY_SITE_NAME
,      OWNING_SITE_ID
,      OWNING_SITE_NAME
,      END_ORDER_PUBLISHER_SITE_ID
,      END_ORDER_PUBLISHER_SITE_NAME
,      END_ORDER_PUBLISHER_NAME
,      PUBLISHER_ITEM_NAME
,      TRADING_PARTNER_ITEM_NAME
,      PUB_ITEM_DESCRIPTIION
,      TP_ITEM_DESCRIPTION
,      PUBLISHER_ORDER_TYPE_DESC
,      TP_ORDER_TYPE_DESC
,      DESIGNATOR
,      CONTEXT
,      UNIT_NUMBER
,      SHIP_METHOD
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PLANNING_GROUP
,      SHIP_FROM_ADDRESS
,      PUBLISHER_ADDRESS
,      CUSTOMER_ADDRESS
,      SUPPLIER_ADDRESS
,      AVERAGE_ANNUAL_DEMAND
,      BILL_OF_LADING_NUMBER
,      BUCKET_TYPE_DESC
,      SERIAL_NUMBER
,      RELEASE_STATUS
,      INVENTORY_STATUS
,      WIP_END_DATE
,      WIP_START_DATE
,      PROMISE_SHIP_DATE
,      NEW_SCHEDULE_END_DATE
,      POSTING_PARTY_NAME
,      PUB_ITEM_DESCRIPTION
,      UOM_CODE
,      TP_UOM_CODE
,      PLANNER_CODE
,      LAST_REFRESH_NUMBER
,      ATTACHMENT_URL
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      KEY_DATE
,      SHIP_DATE
,      RECEIPT_DATE
,      ORIGINAL_PROMISED_DATE
,      REQUEST_DATE
,      PRIMARY_UOM
,      PRIMARY_QUANTITY
,      REF_HEADER_ID
,      REF_LINE_ID
,      CATEGORY_NAME
,      PUBLISHER_ORG_ID
,      SUBSCRIBER_ORG_ID
,      ASSEMBLY_ITEM_ID
,      CATEGORY_ID
,      START_DATE
,      END_DATE
,      PRODUCTION_SEQUENCE
,      SEQ_PLAN_COMPLETION_FLAG
,      INPUT_PLAN_ID
,      END_ASSEMBLY_ITEM_NAME
,      SUBSCRIBER_ADDRESS_ID
,      TP_ORDER_TYPE
,      PROCESSED_FLAG
,      PLANNED_WIP_START_DATE
,      PLANNED_WIP_END_DATE
,      SUBINVENTORY_CODE
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      OWNER_ITEM_NAME
,      ITEM_NAME
,      QUANTITY_IN_PROCESS
,      IMPLEMENTED_QUANTITY
,      ITEM_DESCRIPTION
,      CUSTOMER_ITEM_DESCRIPTION
,      SUPPLIER_ITEM_DESCRIPTION
,      OWNER_ITEM_DESCRIPTION
,      TOTAL_QUANTITY
,      TOTAL_PRIMARY_QUANTITY
,      TOTAL_TP_QUANTITY
,      NUMBER1
,      VMI_FLAG
,      ACK_FLAG
,      ACCEPTANCE_REQUIRED_FLAG
,      DOCUMENT_NUMBER
,      RESPONSE_NUMBER
,      NEED_BY_DATE
,      PROMISED_DATE
,      BASE_ITEM_ID
,      BASE_ITEM_NAME
,      SHIPPING_CONTROL
,      LINK_TRANS_ID
,      INTERNAL_FLAG
,      SOURCE_DELIVERY_ID
,      SR_DELIVERY_STATUS_CODE
,      SHIPPING_CONTROL_CODE
,      END_ORDER_TYPE_DESC
,      DEMAND_CLASS
FROM MSC.MSC_SUP_DEM_ENTRIES;

Dependencies

[top of page]

MSC.MSC_SUP_DEM_ENTRIES does not reference any database object

MSC.MSC_SUP_DEM_ENTRIES is referenced by following:

APPS: MSC_SUP_DEM_ENTRIES; MSC_TRG_AUDIT