[Home] [Help] [Dependency Information]

VIEW: APPS.PMIFV_LOT_EVENT_V

Object Details

Object Name:	PMIFV_LOT_EVENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIFV_LOT_EVENT_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

APPS

IC_ITEM_MST

IC_LOTS_MST

IC_TRAN_CMP

IC_TRAN_PND

APPS.PMIFV_LOT_EVENT_V is not referenced by any database object