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_RET_SALES_ORDERS_VAL_V

Object Details

Object Name:	WIP_RET_SALES_ORDERS_VAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_RET_SALES_ORDERS_VAL_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
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
REVISION	VARCHAR2	(3)		The item revision reserved, only populated for reservation rows that reference a specific revision
WIP_ENTITY_ID	NUMBER			Header id of reservation supply source, for example if supply source is WIP then it is WIP_DISCRETE_JOBS.WIP_ENTITY_ID
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
DEMAND_SOURCE_LINE	VARCHAR2	(30)		Line id of demand source. For Sales Order demand this is: SO_LINES.LINE_ID
ORDER_LINE	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)
SHIPMENT	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.
REQUEST_DATE	DATE		Yes	Planned ship date for summary demand. Parent planned ship date - ATP_LEAD_TIME for derived demand
QUANTITY	NUMBER			Quantity remaining on the sales order
SUBINVENTORY	VARCHAR2	(10)		Subinventory demanded or reserved, can be populated for summary demand
LOCATOR_ID	NUMBER			Location identifier for reserved item

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      WIP_ENTITY_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      ORDER_LINE
,      DEMAND_SOURCE_DELIVERY
,      SHIPMENT
,      REQUEST_DATE
,      QUANTITY
,      SUBINVENTORY
,      LOCATOR_ID
FROM APPS.WIP_RET_SALES_ORDERS_VAL_V;

Dependencies

[top of page]

APPS.WIP_RET_SALES_ORDERS_VAL_V references the following:

APPS: MTL_DEMAND

APPS.WIP_RET_SALES_ORDERS_VAL_V is not referenced by any database object