APPS.GME_RESERVATIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 128: FROM mtl_material_transactions_temp

124: AND mr.subinventory_code = loc.subinventory_code(+)
125: AND mr.locator_id = loc.inventory_location_id(+)
126: AND (p_lot_number IS NULL OR mr.lot_number = p_lot_number)
127: AND NOT EXISTS (SELECT 1
128: FROM mtl_material_transactions_temp
129: WHERE reservation_id = mr.reservation_id)
130: ORDER BY mr.requirement_date;
131: EXCEPTION
132: WHEN OTHERS THEN

Line 457: FROM mtl_material_transactions_temp

453: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
454: AND demand_source_header_id = v_batch_id
455: AND demand_source_line_id = v_material_detail_id
456: AND NOT EXISTS (SELECT 1
457: FROM mtl_material_transactions_temp
458: WHERE reservation_id = mr.reservation_id)
459: ORDER BY mr.requirement_date, mr.reservation_id; -- nsinghi bug#5176319. Add mr.reservation_id in order by clause.
460: error_dispense_mat EXCEPTION;
461: BEGIN

Line 538: FROM mtl_material_transactions_temp

534: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
535: AND demand_source_header_id = v_batch_id
536: AND demand_source_line_id = v_material_detail_id
537: AND EXISTS (SELECT 1
538: FROM mtl_material_transactions_temp
539: WHERE reservation_id = mr.reservation_id)
540: UNION ALL
541: SELECT mr.*
542: FROM mtl_reservations mr

Line 637: mtl_material_transactions_temp mmtt ,

633: ,Nvl(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)secondary_quantity /* Changed in Bug No.9946085 */
634: ,mmtt.secondary_uom_code
635: FROM mtl_txn_request_lines l,
636: mtl_txn_request_headers h ,
637: mtl_material_transactions_temp mmtt ,
638: mtl_transaction_lots_temp mtlt
639: WHERE l.transaction_source_type_id =
640: gme_common_pvt.g_txn_source_type
641: AND l.txn_source_id = v_batch_id

Line 1157: FROM mtl_material_transactions_temp

1153: AND mr.demand_source_line_id = l_mtl_dtl_rec.material_detail_id
1154: AND ((p_supply_sub_only = fnd_api.g_false) OR (mr.subinventory_code = l_mtl_dtl_rec.subinventory))
1155: AND (p_locator_only = fnd_api.g_false OR NVL(mr.locator_id, '-1') = NVL(l_mtl_dtl_rec.locator_id, '-1')); -- Bug 12737393
1156: /* AND NOT EXISTS (SELECT 1
1157: FROM mtl_material_transactions_temp
1158: WHERE reservation_id = mr.reservation_id); */ /* Commented code in Bug No.9946983*/
1159:
1160: matl_fetch_error EXCEPTION;
1161: get_resv_qty_error EXCEPTION;

Line 1543: FROM mtl_material_transactions_temp

1539: AND demand_source_header_id = v_batch_id
1540: AND demand_source_line_id = v_material_detail_id
1541: AND NOT EXISTS (
1542: SELECT 1
1543: FROM mtl_material_transactions_temp
1544: WHERE reservation_id =
1545: mr.reservation_id) );
1546: BEGIN
1547: IF g_debug <= gme_debug.g_log_procedure THEN