[Home] [Help] [Dependency Information]
Object Name: | GMI_LOTS_SOURCE_LIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.GMI_LOTS_SOURCE_LIST_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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 Lot Source, and the user has submitted query parameters through the Find dialogue box. In addition to the columns to support the Find parameters, this view also provides an indicator for whether the product lot displayed has as it's source, one or more ingredient lots. That way the form can display a visual queue that another level of explosion is possible.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_DESC1 | VARCHAR2 | (70) | ||
ITEM_ID | NUMBER | (10) | ||
LOT_ID | NUMBER | (10) | ||
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
CREATION_DATE | DATE | |||
QC_GRADE | VARCHAR2 | (4) | ||
ORGN_CODE | VARCHAR2 | (4) | ||
VENDOR_NO | VARCHAR2 | (32) | ||
HAS_CHILD | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_NO
, ITEM_DESC1
, ITEM_ID
, LOT_ID
, LOT_NO
, SUBLOT_NO
, CREATION_DATE
, QC_GRADE
, ORGN_CODE
, VENDOR_NO
, HAS_CHILD
FROM APPS.GMI_LOTS_SOURCE_LIST_V;
APPS.GMI_LOTS_SOURCE_LIST_V is not referenced by any database object
|
|
|