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.

APPS.INV_LABEL_PVT1 dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2986: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

2982: where mmtt.transaction_temp_id = p_transaction_id
2983: and mtlt.transaction_temp_id = mmtt.transaction_temp_id;
2984:
2985: SELECT Nvl(Sum(primary_transaction_quantity),0) INTO l_moqd_quantity
2986: FROM mtl_onhand_quantities_detail moqd , mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
2987: WHERE mmtt.transaction_temp_id = p_transaction_id
2988: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
2989: and moqd.lot_number = mtlt.lot_number
2990: and nvl(mmtt.lpn_id , -999) = nvl(moqd.lpn_id , -999)