[Home] [Help] [Dependency Information]
Object Name: | PMIFV_LOT_EVENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_LOT_EVENT_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view is used to access inventory events involving each lot, covering pending
and completed transactions from IC_TRAN_PND and IC_TRAN_CMP. Transaction quantities
are summed at a logical transaction level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | ||
LOT_ID | NUMBER | (10) | ||
TRANSACTION_DATE | DATE | |||
ORGANIZATION_CODE | VARCHAR2 | (4) | ||
DOCUMENT_TYPE | VARCHAR2 | (4) | ||
DOCUMENT_ID | NUMBER | (10) | ||
LINE_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
ITEM_UOM | VARCHAR2 | (4) | ||
ITEM_UOM2 | VARCHAR2 | (4) | ||
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_QUANTITY_UOM2 | NUMBER | |||
WAREHOUSE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
QC_GRADE | VARCHAR2 | (4) | ||
LOT_STATUS | VARCHAR2 | (4) | ||
REASON_CODE | VARCHAR2 | (4) | ||
TRANSACTION_COMPLETE_INDICATOR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, LOT_ID
, TRANSACTION_DATE
, ORGANIZATION_CODE
, DOCUMENT_TYPE
, DOCUMENT_ID
, LINE_ID
, ITEM_NO
, ITEM_DESCRIPTION
, ITEM_UOM
, ITEM_UOM2
, LOT_NO
, SUBLOT_NO
, TRANSACTION_QUANTITY
, TRANSACTION_QUANTITY_UOM2
, WAREHOUSE
, LOCATION
, QC_GRADE
, LOT_STATUS
, REASON_CODE
, TRANSACTION_COMPLETE_INDICATOR
FROM APPS.PMIFV_LOT_EVENT_V;
APPS.PMIFV_LOT_EVENT_V is not referenced by any database object
|
|
|