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.

VIEW: APPS.PMIFV_LOT_SHARED_ONHAND_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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