APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_RESERVATIONS

Line 737: -- transfer reservation is taking care of detailed_quantity in mtl_reservations

733:
734: -- delete task
735: DELETE FROM wms_dispatched_tasks
736: WHERE transaction_temp_id = l_mmtt_id;
737: -- transfer reservation is taking care of detailed_quantity in mtl_reservations
738: -- zero the quantity for original mmtt line so pick release is going to work
739:
740: /* update mtl_material_transactions_temp
741: set primary_quantity = 0

Line 1267: update mtl_reservations

1263: if (l_reservation_id is not null) then
1264:
1265: if l_cc_transfer_flag = 'F' then
1266: mdebug(' cycle count reservation transfer failed');
1267: update mtl_reservations
1268: set detailed_quantity = detailed_quantity - l_lot_qty
1269: , last_update_date = SYSDATE
1270: , last_updated_by = l_user_id
1271: WHERE organization_id = l_organization_id

Line 1282: from mtl_reservations

1278: select primary_reservation_quantity
1279: ,detailed_quantity
1280: into l_primary_reservation_quantity
1281: ,l_detailed_quantity
1282: from mtl_reservations
1283: WHERE organization_id = l_organization_id
1284: AND reservation_id = l_reservation_id;
1285: exception
1286: WHEN NO_DATA_FOUND THEN

Line 2031: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr

2027: END IF;
2028: SELECT nvl(mmtt.reservation_id,-1) , mr.primary_reservation_quantity ,
2029: mr.reservation_quantity, mr.primary_uom_code , mr.reservation_uom_code
2030: INTO l_reservation_id , l_pri_rsv_qty, l_rsv_qty , l_pri_rsv_uom, l_rsv_uom
2031: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr
2032: WHERE mmtt.transaction_temp_id = l_txn_temp_id
2033: AND mr.reservation_id = mmtt.reservation_id ;
2034:
2035: IF (l_debug = 1) THEN