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 1268: FROM wsh_delivery_details

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

Line 1317: FROM wsh_delivery_details wdd

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