[Home] [Help] [Dependency Information]
Object Name: | GMI_LOTS_EVENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.GMI_LOTS_EVENT_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 Events tab of the Lot Genealogy Inquiry. It lists all of the inventory transactions that involved the lot highlighted (in the Genealogy Navigator), along with organization, business document number, and key inventory transaction attributes. Rather than display every row in the inventory transaction tables, transaction quantities are summed for the key attributes displayed (lot, date time, warehouse location), and only displayed if the sum is not zero.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | (10) | ||
PRODUCT_LOT_ID | NUMBER | (10) | ||
TRANS_DATE | DATE | |||
ORGN_CODE | VARCHAR2 | (4) | ||
DOC_TYPE | VARCHAR2 | (4) | ||
DOC_ID | NUMBER | (10) | ||
LINE_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | Yes | |
ITEM_DESC1 | VARCHAR2 | (70) | Yes | |
ITEM_UM | VARCHAR2 | (4) | Yes | |
ITEM_UM2 | VARCHAR2 | (4) | ||
LOT_NO | VARCHAR2 | (32) | Yes | |
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) | ||
REASON_CODE | VARCHAR2 | (4) | ||
COMPLETED_IND | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PRODUCT_ITEM_ID
, PRODUCT_LOT_ID
, TRANS_DATE
, ORGN_CODE
, DOC_TYPE
, DOC_ID
, LINE_ID
, ITEM_NO
, ITEM_DESC1
, ITEM_UM
, ITEM_UM2
, LOT_NO
, SUBLOT_NO
, SUM_TRANS_QTY1
, SUM_TRANS_QTY2
, WHSE_CODE
, LOCATION
, QC_GRADE
, LOT_STATUS
, REASON_CODE
, COMPLETED_IND
FROM APPS.GMI_LOTS_EVENT_V;
APPS.GMI_LOTS_EVENT_V is not referenced by any database object
|
|
|