APPS.INV_MO_CANCEL_PVT dependencies on WSH_DELIVERY_DETAILS

Line 145: FROM wsh_delivery_details

141: WHERE move_order_line_id = p_line_id);
142:
143: CURSOR c_wdd_requested_qty is
144: SELECT sum(requested_quantity), sum(requested_quantity2)--INVCONV
145: FROM wsh_delivery_details
146: WHERE move_order_line_id = p_line_id
147: AND released_status ='S';
148:
149: --

Line 1266: FROM wsh_delivery_details

1262: /*Bug#5095840. Added the below cursor to fetch the source line id
1263: if 'p_txn_source_line_id' is passed as NULL.*/
1264: CURSOR c_txn_source_line IS
1265: SELECT source_line_id
1266: FROM wsh_delivery_details
1267: WHERE move_order_line_id IS NOT NULL
1268: AND move_order_line_id = p_line_id
1269: AND released_status = 'S';
1270:

Line 1315: FROM wsh_delivery_details wdd

1311: , wdd.requested_quantity
1312: , wdd.requested_quantity_uom
1313: , wdd.requested_quantity2
1314: , wdd.requested_quantity_uom2
1315: FROM wsh_delivery_details wdd
1316: WHERE wdd.delivery_detail_id = p_wdd_id
1317: FOR UPDATE NOWAIT;
1318:
1319: l_wdd_rec c_lock_wdd%ROWTYPE;