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_SALES_ORDERS

Object Details

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

This table stores sales order demand and reservations from source application instances.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Column
MSC_SALES_ORDERS_N1	NORMAL	NONUNIQUE	SR_INSTANCE_ID INVENTORY_ITEM_ID ORGANIZATION_ID DEMAND_SOURCE_TYPE DEMAND_SOURCE_HEADER_ID
MSC_SALES_ORDERS_N2	NORMAL	NONUNIQUE	SR_INSTANCE_ID DEMAND_ID RESERVATION_TYPE
MSC_SALES_ORDERS_N3	NORMAL	NONUNIQUE	SR_INSTANCE_ID DEMAND_SOURCE_LINE
MSC_SALES_ORDERS_N4	NORMAL	NONUNIQUE	SR_INSTANCE_ID DEMAND_SOURCE_TYPE SUPPLY_ID
MSC_SALES_ORDERS_N5	NORMAL	NONUNIQUE	SR_INSTANCE_ID ROW_TYPE SR_DEMAND_ID
MSC_SALES_ORDERS_N6	NORMAL	NONUNIQUE	SR_INSTANCE_ID SR_DEMAND_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_ID	NUMBER		Yes	Unique identifier of a demand row from source application instance
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
DEMAND_SOURCE_TYPE	NUMBER		Yes	Code to indicate the source of the demand
DEMAND_SOURCE_HEADER_ID	NUMBER		Yes	Header ID for the source of the demand.
DEMAND_SOURCE_LINE	VARCHAR2	(30)		Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID from source application instance.
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID) from source application instance.
DEMAND_SOURCE_NAME	VARCHAR2	(30)		Identifier for user-defined Source Type
PRIMARY_UOM_QUANTITY	NUMBER		Yes	Demanded or reserved quantity expressed in the item's primary unit of measure
RESERVATION_TYPE	NUMBER			Code for type of reservation
RESERVATION_QUANTITY	NUMBER			Total quantity reserved expressed in primary unit of measure. Only populated for summary and derived demand rows.
COMPLETED_QUANTITY	NUMBER		Yes	Shipped quantity in primary unit of measure code.
REQUIREMENT_DATE	DATE		Yes	Planned ship date for summary demand. Parent planned ship date - ATP_LEAD_TIME for derived demand
SUBINVENTORY	VARCHAR2	(10)		Subinventory demanded or reserved, can be populated for summary demand
DEMAND_CLASS	VARCHAR2	(34)		Demand class code (containing sr_instance_code \|\| ':' \|\| demand class code from source application instance)
PARENT_DEMAND_ID	NUMBER			Parent demand identifier
REFRESH_NUMBER	NUMBER			Refresh number populated by the collection program
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
SALES_ORDER_NUMBER	VARCHAR2	(122)		Sales order number
SALESREP_CONTACT	VARCHAR2	(100)		Salesrep contact
ORDERED_ITEM_ID	NUMBER			Ordered item identifier
AVAILABLE_TO_MRP	VARCHAR2	(1)		Available to MRP flag
CUSTOMER_ID	NUMBER			Customer identifier
SHIP_TO_SITE_USE_ID	NUMBER			Ship to identifier of the sales order
BILL_TO_SITE_USE_ID	NUMBER			Bill to identifier of the sales order
LINE_NUM	NUMBER			Sales order line number
TERRITORY_ID	NUMBER			Territory identifier of the sales order
UPDATE_SEQ_NUM	NUMBER			Update sequence number
DEMAND_TYPE	NUMBER			Demand type
PROJECT_ID	NUMBER			Project identifier
TASK_ID	NUMBER			Task identifier
PLANNING_GROUP	VARCHAR2	(30)		Planning group
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Unit number identifier
DEMAND_PRIORITY	NUMBER			Demand priority
ATP_REFRESH_NUMBER	NUMBER			ATP refresh number
REQUEST_DATE	DATE			Request Date
SELLING_PRICE	NUMBER			Unique identifier of a demand row from source application instance
DEMAND_VISIBLE	VARCHAR2	(1)		Demand Visibility Flag
FORECAST_VISIBLE	VARCHAR2	(1)		Forecast Visibility Flag
CTO_FLAG	NUMBER			Unique identifier of a demand row from source application instance
SUPPLY_ID	NUMBER			Unique identifier of a demand row from source application instance
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)		Original System Reference
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)		Original System Line Reference
SOURCE_ORGANIZATION_ID	NUMBER			Source application identifier
SOURCE_ORG_INSTANCE_ID	NUMBER			Source Org Instance Identifier
OLD_PRIMARY_UOM_QUANTITY	NUMBER			for ATP SUmmary Calculation
OLD_RESERVATION_QUANTITY	NUMBER			for ATP SUmmary Calculation
OLD_COMPLETED_QUANTITY	NUMBER			for ATP SUmmary Calculation
OLD_REQUIREMENT_DATE	DATE			for ATP SUmmary Calculation
ORIGINAL_ITEM_ID	NUMBER			Original Item Id
PROMISE_DATE	DATE			Date promised to the customer
LINK_TO_LINE_ID	NUMBER			Parent Line Identifier
PARENT_ID	NUMBER			Parent Demand Identifier
CUST_PO_NUMBER	VARCHAR2	(50)		Customer Purchase Order Number
CUSTOMER_LINE_NUMBER	VARCHAR2	(50)		Refrence Information.Contains customers line number, If specified while importing an order.
SR_DEMAND_ID	NUMBER			Source Demand Identifier
RECORD_SOURCE	NUMBER			For sales orders generated by ATP this field will have value 2. If this field is 1 or null then the sales order is collected from source.
MFG_LEAD_TIME	NUMBER
ORDER_DATE_TYPE_CODE	NUMBER
SCHEDULE_ARRIVAL_DATE	DATE
LATEST_ACCEPTABLE_DATE	DATE
SHIPPING_METHOD_CODE	VARCHAR2	(30)
ORG_FIRM_FLAG	NUMBER
ATP_OVERRIDE_FLAG	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
SHIP_SET_ID	NUMBER
ARRIVAL_SET_ID	NUMBER
ATO_LINE_ID	NUMBER
ARRIVAL_SET_NAME	VARCHAR2	(30)
SHIP_SET_NAME	VARCHAR2	(30)
REQUEST_SHIP_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
SALESREP_ID	NUMBER
INTRANSIT_LEAD_TIME	NUMBER
SR_CUSTOMER_ACCT_ID	NUMBER
PREV_COLL_ITEM_ID	NUMBER
ROW_TYPE	NUMBER
SR_SO_LINEID	NUMBER
MIN_REM_SHELF_LIFE_DAYS	NUMBER

Query Text

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


SELECT DEMAND_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_NAME
,      PRIMARY_UOM_QUANTITY
,      RESERVATION_TYPE
,      RESERVATION_QUANTITY
,      COMPLETED_QUANTITY
,      REQUIREMENT_DATE
,      SUBINVENTORY
,      DEMAND_CLASS
,      PARENT_DEMAND_ID
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SALES_ORDER_NUMBER
,      SALESREP_CONTACT
,      ORDERED_ITEM_ID
,      AVAILABLE_TO_MRP
,      CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      LINE_NUM
,      TERRITORY_ID
,      UPDATE_SEQ_NUM
,      DEMAND_TYPE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      END_ITEM_UNIT_NUMBER
,      DEMAND_PRIORITY
,      ATP_REFRESH_NUMBER
,      REQUEST_DATE
,      SELLING_PRICE
,      DEMAND_VISIBLE
,      FORECAST_VISIBLE
,      CTO_FLAG
,      SUPPLY_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      OLD_PRIMARY_UOM_QUANTITY
,      OLD_RESERVATION_QUANTITY
,      OLD_COMPLETED_QUANTITY
,      OLD_REQUIREMENT_DATE
,      ORIGINAL_ITEM_ID
,      PROMISE_DATE
,      LINK_TO_LINE_ID
,      PARENT_ID
,      CUST_PO_NUMBER
,      CUSTOMER_LINE_NUMBER
,      SR_DEMAND_ID
,      RECORD_SOURCE
,      MFG_LEAD_TIME
,      ORDER_DATE_TYPE_CODE
,      SCHEDULE_ARRIVAL_DATE
,      LATEST_ACCEPTABLE_DATE
,      SHIPPING_METHOD_CODE
,      ORG_FIRM_FLAG
,      ATP_OVERRIDE_FLAG
,      SHIP_TO_LOCATION_ID
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      ATO_LINE_ID
,      ARRIVAL_SET_NAME
,      SHIP_SET_NAME
,      REQUEST_SHIP_DATE
,      SCHEDULE_SHIP_DATE
,      SALESREP_ID
,      INTRANSIT_LEAD_TIME
,      SR_CUSTOMER_ACCT_ID
,      PREV_COLL_ITEM_ID
,      ROW_TYPE
,      SR_SO_LINEID
,      MIN_REM_SHELF_LIFE_DAYS
FROM MSC.MSC_SALES_ORDERS;

Dependencies

[top of page]

MSC.MSC_SALES_ORDERS does not reference any database object

MSC.MSC_SALES_ORDERS is referenced by following:

APPS: MSC_SALES_ORDERS