APPS.GME_MOBILE_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 81: FROM mtl_material_transactions_temp

77: AND mr.demand_source_type_id = 5
78: AND mr.demand_source_header_id = p_batch_id
79: AND mr.demand_source_line_id = p_material_detail_id
80: AND NOT EXISTS (SELECT 1
81: FROM mtl_material_transactions_temp
82: WHERE reservation_id = mr.reservation_id)
83: ORDER BY mr.requirement_date, mr.reservation_id;
84:
85: END Rsrv_LoV;

Line 2858: FROM mtl_material_transactions_temp

2854: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2855: AND subinventory_code = p_subinventory_code
2856: AND NVL(mr.locator_id, -1) = NVL(NVL(p_locator_id, mr.locator_id), -1)
2857: AND NOT EXISTS (SELECT 1
2858: FROM mtl_material_transactions_temp
2859: WHERE reservation_id = mr.reservation_id);
2860: ELSE
2861:
2862: OPEN x_lot_num_lov FOR

Line 2879: FROM mtl_material_transactions_temp

2875: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2876: AND demand_source_header_id = p_batch_id
2877: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2878: AND NOT EXISTS (SELECT 1
2879: FROM mtl_material_transactions_temp
2880: WHERE reservation_id = mr.reservation_id);
2881: END IF;
2882:
2883: END Lot_LoV_Rsrv;