APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_RESERVATIONS

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

849: -- delete task
850: DELETE FROM wms_dispatched_tasks
851: WHERE transaction_temp_id = l_mmtt_id;
852:
853: -- transfer reservation is taking care of detailed_quantity in mtl_reservations
854: -- zero the quantity for original mmtt line so pick release is going to work
855:
856: mdebug('l_parent_line_id:'||l_parent_line_id);
857:

Line 1717: UPDATE mtl_reservations

1713:
1714: IF (l_reservation_id IS NOT NULL) THEN
1715: IF l_cc_transfer_flag = 'F' THEN
1716: mdebug(' cycle count reservation transfer failed');
1717: UPDATE mtl_reservations
1718: SET detailed_quantity = detailed_quantity - l_lot_qty
1719: , secondary_detailed_quantity = secondary_detailed_quantity - l_sec_lot_qty --bug 8197499
1720: , last_update_date = SYSDATE
1721: , last_updated_by = l_user_id

Line 1732: FROM mtl_reservations

1728: SELECT primary_reservation_quantity
1729: ,detailed_quantity
1730: INTO l_primary_reservation_quantity
1731: ,l_detailed_quantity
1732: FROM mtl_reservations
1733: WHERE organization_id = l_organization_id
1734: AND reservation_id = l_reservation_id;
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN

Line 2628: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr

2624: ,l_sec_rsv_qty
2625: ,l_sec_rsv_uom
2626: ,l_rsv_lot_num
2627: ,l_rsv_org_id
2628: FROM mtl_material_transactions_temp mmtt , mtl_reservations mr
2629: WHERE mmtt.transaction_temp_id = l_txn_temp_id
2630: AND mr.reservation_id = mmtt.reservation_id ;
2631:
2632: IF (l_debug = 1) THEN