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: TableMSC.MSC_SALES_ORDERS
Subobject Name:
Status: VALID

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

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_SALES_ORDERS_N1 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnDEMAND_SOURCE_TYPE
ColumnDEMAND_SOURCE_HEADER_ID
MSC_SALES_ORDERS_N2 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnDEMAND_ID
ColumnRESERVATION_TYPE
MSC_SALES_ORDERS_N3 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnDEMAND_SOURCE_LINE
MSC_SALES_ORDERS_N4 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnDEMAND_SOURCE_TYPE
ColumnSUPPLY_ID
MSC_SALES_ORDERS_N5 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnROW_TYPE
ColumnSR_DEMAND_ID
MSC_SALES_ORDERS_N6 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnSR_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

REVISED_DMD_DATE DATE

Revised Demand Date
REVISED_DMD_PRIORITY NUMBER

Revised Demand Priority
ITEM_TYPE_ID NUMBER

ITEM_TYPE_VALUE 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
,      REVISED_DMD_DATE
,      REVISED_DMD_PRIORITY
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
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:

SchemaMSC
ViewMSC_SALES_ORDERS#