APPS.GME_RESERVATIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 71: FROM mtl_material_transactions_temp

67: AND mr.subinventory_code = loc.subinventory_code(+)
68: AND mr.locator_id = loc.inventory_location_id(+)
69: AND (p_lot_number IS NULL OR mr.lot_number = p_lot_number)
70: AND NOT EXISTS (SELECT 1
71: FROM mtl_material_transactions_temp
72: WHERE reservation_id = mr.reservation_id)
73: ORDER BY mr.requirement_date;
74: EXCEPTION
75: WHEN OTHERS THEN

Line 390: FROM mtl_material_transactions_temp

386: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
387: AND demand_source_header_id = v_batch_id
388: AND demand_source_line_id = v_material_detail_id
389: AND NOT EXISTS (SELECT 1
390: FROM mtl_material_transactions_temp
391: WHERE reservation_id = mr.reservation_id)
392: ORDER BY mr.requirement_date, mr.reservation_id; -- nsinghi bug#5176319. Add mr.reservation_id in order by clause.
393: error_dispense_mat EXCEPTION;
394: BEGIN

Line 873: FROM mtl_material_transactions_temp

869: AND mr.demand_source_line_id = l_mtl_dtl_rec.material_detail_id
870: AND ( (p_supply_sub_only = fnd_api.g_false)
871: OR (mr.subinventory_code = l_mtl_dtl_rec.subinventory) )
872: AND NOT EXISTS (SELECT 1
873: FROM mtl_material_transactions_temp
874: WHERE reservation_id = mr.reservation_id);
875:
876: matl_fetch_error EXCEPTION;
877: get_resv_qty_error EXCEPTION;

Line 1250: FROM mtl_material_transactions_temp

1246: AND demand_source_header_id = v_batch_id
1247: AND demand_source_line_id = v_material_detail_id
1248: AND NOT EXISTS (
1249: SELECT 1
1250: FROM mtl_material_transactions_temp
1251: WHERE reservation_id =
1252: mr.reservation_id) );
1253: BEGIN
1254: IF g_debug <= gme_debug.g_log_procedure THEN