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: APPS.WIP_SALES_ORDER_LINES_V

Object Details

Object Name:	WIP_SALES_ORDER_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_SALES_ORDER_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_SOURCE_LINE	VARCHAR2	(30)		Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID
USER_LINE_NUM	VARCHAR2	(30)		User identifier of demand source. For sales order demand this is SO_LINES.LINE_NUMBER
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID)
USER_DELIVERY	VARCHAR2	(30)		User identifier of demand source. For sales order demand it is taken from SO_LINES.LINE_NUMBER of the schedule line, used for display only.
REQUIREMENT_DATE	DATE		Yes	Planned ship date for summary demand. Parent planned ship date - ATP_LEAD_TIME for derived demand
PRIMARY_UOM_QUANTITY	NUMBER		Yes	Demanded or reserved quantity expressed in the item's primary unit of measure as defined in MTL_SYSTEM_ITEMS
UOM_CONVERSION_RATE	NUMBER			Conversion rate for the UOM
UOM_CODE	VARCHAR2	(3)	Yes	Unit of measure of LINE_ITEM_QUANTITY column
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
DEMAND_CLASS	VARCHAR2	(30)		Demand class of the demand row
SUBINVENTORY	VARCHAR2	(10)		Subinventory demanded or reserved, can be populated for summary demand
DEMAND_SOURCE_HEADER_ID	NUMBER		Yes	Header ID for the source of the demand. For Sales order demand: MTL_SALES_ORDERS.SALES_ORDER_ID, For Account number: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID, For Account Alias: MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
ORGANIZATION_ID	NUMBER		Yes	Organization identifier

Query Text

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


SELECT DEMAND_SOURCE_LINE
,      USER_LINE_NUM
,      DEMAND_SOURCE_DELIVERY
,      USER_DELIVERY
,      REQUIREMENT_DATE
,      PRIMARY_UOM_QUANTITY
,      UOM_CONVERSION_RATE
,      UOM_CODE
,      INVENTORY_ITEM_ID
,      DEMAND_CLASS
,      SUBINVENTORY
,      DEMAND_SOURCE_HEADER_ID
,      ORGANIZATION_ID
FROM APPS.WIP_SALES_ORDER_LINES_V;

Dependencies

[top of page]

APPS.WIP_SALES_ORDER_LINES_V references the following:

APPS: MTL_DEMAND; MTL_SYSTEM_ITEMS

APPS.WIP_SALES_ORDER_LINES_V is referenced by following:

APPS: MRP_VALIDATE_FLOW_SCHEDULE - show dependent code