VIEW: APPS.PMIFV_LOT_DEST_ONHAND_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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