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

Object Details

Object Name:	PMI_LOT_SOURCE_LEAF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMI_LOT_SOURCE_LEAF_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view lists raw material lots that are used in the manufacture of a product lot.
In this context, a raw material lot is any lot that cannot be further decomposed
into a lower level of constituent ingredients.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
PRODUCT_ITEM_ID	NUMBER		item_id of a product lot
PRODUCT_LOT_ID	NUMBER	Yes	lot_id of a product lot
INGRED_ITEM_ID	NUMBER		item_id of a raw material lot of the product lot
INGRED_LOT_ID	NUMBER	Yes	lot_id of a raw material lot of the product lot

Query Text

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


SELECT PRODUCT_ITEM_ID
,      PRODUCT_LOT_ID
,      INGRED_ITEM_ID
,      INGRED_LOT_ID
FROM APPS.PMI_LOT_SOURCE_LEAF_V;

Dependencies

[top of page]

APPS.PMI_LOT_SOURCE_LEAF_V references the following:

APPS: PMI_LOT_GENEALOGY

APPS.PMI_LOT_SOURCE_LEAF_V is referenced by following:

APPS: PMIBV_LOT_SOURCE_PURCH_V; PMIFV_LOT_SOURCE_PURCH_V; PMI_LOT_SHARED_V