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.MTL_LOT_DEMAND_VAL_V

Object Details

Object Name:	MTL_LOT_DEMAND_VAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_LOT_DEMAND_VAL_V
Subobject Name:
Status:	VALID

The view is based on mtl_lot_numbers and mtl_demand.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOT_NUMBER	VARCHAR2	(80)		The specific lot number reserved, only populated for reservation rows for a specific lot number
EXPIRATION_DATE	DATE			Lot expiration date
PRIMARY_UOM_QUANTITY	NUMBER		Yes	Demanded or reserved quantity expressed in the item's primary unit of measure as defined in MTL_SYSTEM_ITEMS
COMPLETED_QUANTITY	NUMBER		Yes	Shipped quantity in primary unit of measure code.
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
REVISION	VARCHAR2	(3)		The item revision reserved, only populated for reservation rows that reference a specific revision
DEMAND_SOURCE_TYPE	NUMBER		Yes	Code to indicate the source of the demand
SUPPLY_SOURCE_TYPE	NUMBER			Source of supply for reservation, only populated if reservation is not to on hand
RESERVATION_TYPE	NUMBER		Yes	Code for type of reservation
ROW_STATUS_FLAG	NUMBER	(2)		used by the demand management functions to indicate the status of a row; 1 - Active; 2 - Complete
SUPPLY_SOURCE_HEADER_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
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID)
SUBINVENTORY	VARCHAR2	(10)		Subinventory demanded or reserved, can be populated for summary demand
LOCATOR_ID	NUMBER			Location identifier for reserved item
PARENT_LOT_NUMBER	VARCHAR2	(80)		Parent Lot Number
GRADE_CODE	VARCHAR2	(150)		Grade Code - Used By WMS Only

Query Text

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


SELECT LOT_NUMBER
,      EXPIRATION_DATE
,      PRIMARY_UOM_QUANTITY
,      COMPLETED_QUANTITY
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      REVISION
,      DEMAND_SOURCE_TYPE
,      SUPPLY_SOURCE_TYPE
,      RESERVATION_TYPE
,      ROW_STATUS_FLAG
,      SUPPLY_SOURCE_HEADER_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      SUBINVENTORY
,      LOCATOR_ID
,      PARENT_LOT_NUMBER
,      GRADE_CODE
FROM APPS.MTL_LOT_DEMAND_VAL_V;

Dependencies

[top of page]

APPS.MTL_LOT_DEMAND_VAL_V references the following:

APPS: MTL_DEMAND; MTL_LOT_NUMBERS

APPS.MTL_LOT_DEMAND_VAL_V is not referenced by any database object