eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PMIFV_LOT_DEST_ONHAND_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	PMI View for Lot Genealogy Where Used Onhand
Implementation/DBA Data:	APPS.PMIFV_LOT_DEST_ONHAND_V

View Text

SELECT GEN.PRODUCT_ITEM_ID
, GEN.PRODUCT_LOT_ID
, GEN.INGRED_ITEM_ID
, GEN.INGRED_LOT_ID
, INV.WHSE_CODE
, INV.LOCATION
, INV.LOCT_ONHAND
, INV.LOCT_ONHAND2
, INV.LOT_STATUS
, I_ITEM.ITEM_NO
, I_ITEM.ITEM_DESC1
, I_ITEM.ITEM_UM
, I_ITEM.ITEM_UM2
, I_LOT.LOT_NO
, I_LOT.SUBLOT_NO
, P_ITEM.ITEM_NO
, P_ITEM.ITEM_DESC1
, P_ITEM.ITEM_UM
, P_ITEM.ITEM_UM2
, P_ITEM.INV_CLASS
, P_ITEM.PLANNING_CLASS
, P_ITEM.SALES_CLASS
, P_LOT.LOT_NO
, P_LOT.SUBLOT_NO
FROM PMI_LOT_GENEALOGY GEN
, IC_LOCT_INV INV
, IC_ITEM_MST I_ITEM
, IC_LOTS_MST I_LOT
, IC_ITEM_MST P_ITEM
, IC_LOTS_MST P_LOT
WHERE INV.ITEM_ID = GEN.PRODUCT_ITEM_ID
AND INV.LOT_ID = GEN.PRODUCT_LOT_ID
AND I_ITEM.ITEM_ID = I_LOT.ITEM_ID
AND I_LOT.ITEM_ID = GEN.INGRED_ITEM_ID
AND I_LOT.LOT_ID = GEN.INGRED_LOT_ID
AND P_ITEM.ITEM_ID = GEN.PRODUCT_ITEM_ID
AND P_LOT.ITEM_ID = GEN.PRODUCT_ITEM_ID
AND P_LOT.LOT_ID = GEN.PRODUCT_LOT_ID WITH READ ONLY

Columns

Name
PRODUCT_ITEM_ID
PRODUCT_LOT_ID
INGREDIENT_ITEM_ID
INGREDIENT_LOT_ID
PRODUCT_WAREHOUSE
PRODUCT_LOCATION
PRODUCT_LOCATION_ONHAND
PRODUCT_LOCATION_ONHAND_UOM2
PRODUCT_LOT_STATUS
INGREDIENT_ITEM_NO
INGREDIENT_ITEM_DESCRIPTION
INGREDIENT_ITEM_UOM
INGREDIENT_ITEM_UOM2
INGREDIENT_LOT_NO
INGREDIENT_SUBLOT_NO
PRODUCT_ITEM_NO
PRODUCT_ITEM_DESCRIPTION
PRODUCT_ITEM_UOM
PRODUCT_ITEM_UOM2
PRODUCT_ITEM_INV_CLASS
PRODUCT_ITEM_PLAN_CLASS
PRODUCT_ITEM_SALES_CLASS
PRODUCT_LOT_NO
PRODUCT_SUBLOT_NO