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]

VIEW: MSC.MSC_SALES_ORDERS#

Object Details

Object Name:	MSC_SALES_ORDERS#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DEMAND_ID	NUMBER		Yes
SR_INSTANCE_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
DEMAND_SOURCE_TYPE	NUMBER		Yes
DEMAND_SOURCE_HEADER_ID	NUMBER		Yes
DEMAND_SOURCE_LINE	VARCHAR2	(30)
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)
DEMAND_SOURCE_NAME	VARCHAR2	(30)
PRIMARY_UOM_QUANTITY	NUMBER		Yes
RESERVATION_TYPE	NUMBER
RESERVATION_QUANTITY	NUMBER
COMPLETED_QUANTITY	NUMBER		Yes
REQUIREMENT_DATE	DATE		Yes
SUBINVENTORY	VARCHAR2	(10)
DEMAND_CLASS	VARCHAR2	(34)
PARENT_DEMAND_ID	NUMBER
REFRESH_NUMBER	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
SALES_ORDER_NUMBER	VARCHAR2	(122)
SALESREP_CONTACT	VARCHAR2	(100)
ORDERED_ITEM_ID	NUMBER
AVAILABLE_TO_MRP	VARCHAR2	(1)
CUSTOMER_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
BILL_TO_SITE_USE_ID	NUMBER
LINE_NUM	NUMBER
TERRITORY_ID	NUMBER
UPDATE_SEQ_NUM	NUMBER
DEMAND_TYPE	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
PLANNING_GROUP	VARCHAR2	(30)
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
DEMAND_PRIORITY	NUMBER
ATP_REFRESH_NUMBER	NUMBER
REQUEST_DATE	DATE
SELLING_PRICE	NUMBER
DEMAND_VISIBLE	VARCHAR2	(1)
FORECAST_VISIBLE	VARCHAR2	(1)
CTO_FLAG	NUMBER
SUPPLY_ID	NUMBER
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_ORG_INSTANCE_ID	NUMBER
OLD_PRIMARY_UOM_QUANTITY	NUMBER
OLD_RESERVATION_QUANTITY	NUMBER
OLD_COMPLETED_QUANTITY	NUMBER
OLD_REQUIREMENT_DATE	DATE
ORIGINAL_ITEM_ID	NUMBER
PROMISE_DATE	DATE
LINK_TO_LINE_ID	NUMBER
PARENT_ID	NUMBER
CUST_PO_NUMBER	VARCHAR2	(50)
CUSTOMER_LINE_NUMBER	VARCHAR2	(50)
SR_DEMAND_ID	NUMBER
RECORD_SOURCE	NUMBER
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_DMD_PRIORITY	NUMBER
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# references the following:

MSC: MSC_SALES_ORDERS

MSC.MSC_SALES_ORDERS# is referenced by following:

APPS: MSC_SALES_ORDERS