[Home] [Help] [Dependency Information]

VIEW: APPS.GMI_LOTS_LIST_V

Object Details

Object Name:	GMI_LOTS_LIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.GMI_LOTS_LIST_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 the basis for the views GMI_LOTS_DEST_LIST_V and GMI_LOTS_SOURCE_LIST_V. This view contains that joins that are common to both of those views. They then call the function that is appropriate for determining whether the listed lot is expandable, depending on the navigation mode (Lot Source or Where Used).

[View Source]

Columns

Query Text

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

SELECT ITEM_NO
,      ITEM_DESC1
,      ITEM_ID
,      INV_CLASS
,      INV_TYPE
,      LOT_ID
,      LOT_NO
,      SUBLOT_NO
,      CREATION_DATE
,      QC_GRADE
,      ORGN_CODE
,      VENDOR_NO
FROM APPS.GMI_LOTS_LIST_V;

Dependencies

[top of page]

APPS

IC_ITEM_MST

IC_LOTS_MST

IC_TRAN_CMP

IC_TRAN_PND

PO_RECV_DTL

PO_VEND_MST

APPS

GMI_LOTS_DEST_LIST_V

GMI_LOTS_SOURCE_LIST_V