APPS.GME_MOBILE_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 101: FROM mtl_material_transactions_temp

97: AND mr.demand_source_header_id = p_batch_id
98: AND mr.demand_source_line_id = p_material_detail_id
99: AND LPN.lpn_id(+) = mr.lpn_id
100: AND NOT EXISTS (SELECT 1
101: FROM mtl_material_transactions_temp
102: WHERE reservation_id = mr.reservation_id)
103: ORDER BY mr.requirement_date, mr.reservation_id;
104:
105: END Rsrv_LoV;

Line 2885: FROM mtl_material_transactions_temp

2881: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2882: AND subinventory_code = p_subinventory_code
2883: AND NVL(mr.locator_id, -1) = NVL(NVL(p_locator_id, mr.locator_id), -1)
2884: AND NOT EXISTS (SELECT 1
2885: FROM mtl_material_transactions_temp
2886: WHERE reservation_id = mr.reservation_id);
2887: ELSE
2888:
2889: OPEN x_lot_num_lov FOR

Line 2906: FROM mtl_material_transactions_temp

2902: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2903: AND demand_source_header_id = p_batch_id
2904: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2905: AND NOT EXISTS (SELECT 1
2906: FROM mtl_material_transactions_temp
2907: WHERE reservation_id = mr.reservation_id);
2908: END IF;
2909:
2910: END Lot_LoV_Rsrv;