View: PMIBV_CURRENTINVENTORY_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Qty and availability info for Items in Inv at the present time by warehouse, loc, lot and item.
Implementation/DBA Data:	APPS.PMIBV_CURRENTINVENTORY_V

View Text

SELECT INV.LOCT_ONHAND
, /* REGULAR ATTRIBUTES */ INV.LOCT_ONHAND2
, INV.WHSE_CODE
, /* ID */ LOT.LOT_ID
, INV.LOCATION
, LOT.ITEM_ID
, INV.LOT_STATUS
, INV.QCHOLD_RES_CODE
, LOT.LOT_NO
, LOT.SUBLOT_NO
, LOT.QC_GRADE
, LOT.EXPIRE_DATE
, LOT.CREATION_DATE
, LOT.VENDOR_LOT_NO
, INV.LAST_UPDATED_BY
, /* WHO */ INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.CREATION_DATE
FROM IC_LOCT_INV INV
, IC_LOTS_MST LOT
WHERE INV.LOT_ID(+) = LOT.LOT_ID
AND INV.ITEM_ID(+) = LOT.ITEM_ID
AND (INV.DELETE_MARK = 0 OR INV.DELETE_MARK IS NULL) WITH READ ONLY

Columns