[Home] [Help] [Dependency Information]
Object Name: | GMI_LOTS_DEST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.GMI_LOTS_DEST_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 Where Used tab of the Lot Genealogy Inquiry when the navigation mode is Where Used. It returns the product lots output by batches, for which the lot highlighted (in the Genealogy Navigator) was used as an ingredient. The Where Used tab, using this view, adds additional attributes that are not displayed in the Lot Genealogy Tree Navigator.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | (10) | ||
PRODUCT_LOT_ID | NUMBER | (10) | ||
TRANS_DATE | DATE | |||
LINE_TYPE | NUMBER | (5) | ||
INGRED_ITEM_ID | NUMBER | (10) | ||
INGRED_LOT_ID | NUMBER | (10) | ||
PRODUCT_ITEM_NO | VARCHAR2 | (32) | ||
PRODUCT_ITEM_DESC1 | VARCHAR2 | (70) | ||
PRODUCT_ITEM_UM | VARCHAR2 | (4) | ||
PRODUCT_ITEM_UM2 | VARCHAR2 | (4) | ||
INV_TYPE | VARCHAR2 | (4) | ||
INV_CLASS | VARCHAR2 | (8) | ||
PRODUCT_LOT_NO | VARCHAR2 | (32) | ||
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) | ||
SUM_TRANS_QTY1 | NUMBER | |||
SUM_TRANS_QTY2 | NUMBER | |||
WHSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
QC_GRADE | VARCHAR2 | (4) | ||
LOT_STATUS | VARCHAR2 | (4) |
Cut, paste (and edit) the following text to query this object:
SELECT PRODUCT_ITEM_ID
, PRODUCT_LOT_ID
, TRANS_DATE
, LINE_TYPE
, INGRED_ITEM_ID
, INGRED_LOT_ID
, PRODUCT_ITEM_NO
, PRODUCT_ITEM_DESC1
, PRODUCT_ITEM_UM
, PRODUCT_ITEM_UM2
, INV_TYPE
, INV_CLASS
, PRODUCT_LOT_NO
, PRODUCT_SUBLOT_NO
, SUM_TRANS_QTY1
, SUM_TRANS_QTY2
, WHSE_CODE
, LOCATION
, QC_GRADE
, LOT_STATUS
FROM APPS.GMI_LOTS_DEST_V;
|
|
|