View: PMIFV_LOT_SHARED_ONHAND_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	This view lists the onhand balances of all prod lots with ING lots.
Implementation/DBA Data:	APPS.PMIFV_LOT_SHARED_ONHAND_V

View Text

SELECT SHARED_V.START_ITEM_ID
, SHARED_V.START_LOT_ID
, SHARED_V.SHARED_ITEM_ID
, SHARED_V.SHARED_LOT_ID
, START_ITEM.ITEM_NO
, START_ITEM.ITEM_DESC1
, START_LOT.LOT_NO
, START_LOT.SUBLOT_NO
, SHARED_ITEM.ITEM_NO
, SHARED_ITEM.ITEM_DESC1
, SHARED_ITEM.ITEM_UM
, SHARED_ITEM.ITEM_UM2
, SHARED_ITEM.INV_CLASS
, SHARED_ITEM.PLANNING_CLASS
, SHARED_ITEM.SALES_CLASS
, SHARED_LOT.LOT_NO
, SHARED_LOT.SUBLOT_NO
, SHARED_INV.LOCT_ONHAND
, SHARED_INV.LOCT_ONHAND2
, SHARED_INV.WHSE_CODE
, SHARED_INV.LOCATION
FROM PMI_LOT_SHARED_V SHARED_V
, IC_ITEM_MST START_ITEM
, IC_LOTS_MST START_LOT
, IC_ITEM_MST SHARED_ITEM
, IC_LOTS_MST SHARED_LOT
, IC_LOCT_INV SHARED_INV
WHERE START_ITEM.ITEM_ID = SHARED_V.START_ITEM_ID
AND START_LOT.ITEM_ID = SHARED_V.START_ITEM_ID
AND START_LOT.LOT_ID = SHARED_V.START_LOT_ID
AND SHARED_ITEM.ITEM_ID = SHARED_V.SHARED_ITEM_ID
AND SHARED_LOT.ITEM_ID = SHARED_V.SHARED_ITEM_ID
AND SHARED_LOT.LOT_ID = SHARED_V.SHARED_LOT_ID
AND SHARED_INV.ITEM_ID = SHARED_V.SHARED_ITEM_ID
AND SHARED_INV.LOT_ID = SHARED_V.SHARED_LOT_ID WITH READ ONLY

Columns