[Home] [Help] [Dependency Information]

VIEW: APPS.GMI_LOTS_DEST_BOM_V

Object Details

Object Name:	GMI_LOTS_DEST_BOM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.GMI_LOTS_DEST_BOM_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

A public view which may be useful for custom reporting or other data
requirements.

This view is used to populate the Lot Genealogy Tree Navigator (on the Lot Genealogy Inquiry) when the navigation mode is Where Used, and the user clicks on a lot to drill "up" in the Lot Genealogy Hierarchy. In addition to giving the keys to the Product Lots for a given Ingredient Lot, this view also provides an indicator for whether the product lot displayed was later used as an ingredient lot. That way the form can display a visual queue that another level of explosion is possible.

[View Source]

Columns

Query Text

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

SELECT DOC_ID
,      PRODUCT_ITEM_ID
,      PRODUCT_LOT_ID
,      INGRED_ITEM_ID
,      INGRED_LOT_ID
,      HAS_CHILD
FROM APPS.GMI_LOTS_DEST_BOM_V;

Dependencies

[top of page]

APPS

GMI_LOTS_BOM_V

GMI_LOT_TRACE_PKG - show dependent code

APPS.GMI_LOTS_DEST_BOM_V is not referenced by any database object