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.WMS_UNLOAD_UTILS_PVT dependencies on MTL_RESERVATIONS

Line 396: mtl_reservations mr,

392:
393: SELECT NVL(mr.lot_number, mtrl.lot_number)
394: INTO l_reserved_lot
395: FROM mtl_material_transactions_temp mmtt,
396: mtl_reservations mr,
397: mtl_txn_request_lines mtrl
398: WHERE mmtt.transaction_temp_id = p_temp_id
399: AND mmtt.organization_id = l_org_id
400: AND mmtt.reservation_id = mr.reservation_id (+)

Line 1227: mtl_reservations mr

1223:
1224: SELECT mr.lot_number
1225: INTO l_reserved_lot
1226: FROM mtl_material_transactions_temp mmttc, mtl_material_transactions_temp mmttp,
1227: mtl_reservations mr
1228: WHERE mmttc.parent_line_id = mmttp.transaction_temp_id
1229: AND mmttc.transaction_temp_id <> mmttc.parent_line_id
1230: AND mmttc.organization_id = l_org_id
1231: AND mmttc.reservation_id = mr.reservation_id (+)

Line 1531: FROM mtl_material_transactions_temp mmtt, mtl_reservations mr

1527: END IF;
1528:
1529: SELECT mr.lot_number
1530: INTO l_reserved_lot
1531: FROM mtl_material_transactions_temp mmtt, mtl_reservations mr
1532: WHERE mmtt.transaction_temp_id = p_temp_id
1533: AND mmtt.organization_id = p_org_id
1534: AND mmtt.reservation_id = mr.reservation_id;
1535: IF ( l_debug = 1 ) THEN