APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on WSH_DELIVERY_DETAILS

Line 260: From wsh_delivery_details

256: AND completed_ind = 0
257: AND delete_mark = 0
258: AND line_detail_id in
259: (Select delivery_detail_id
260: From wsh_delivery_details
261: Where move_order_line_id = l_mo_line_rec.line_id
262: and released_status in ('R','S'));
263:
264: /* If Item is NOT Lot AND NOT Location Controlled */

Line 336: FROM wsh_delivery_details

332: , source_header_id
333: , source_line_id
334: , requested_quantity
335: , requested_quantity2
336: FROM wsh_delivery_details
337: WHERE move_order_line_id = l_mo_line_rec.line_id
338: AND move_order_line_id IS NOT NULL
339: AND released_status = 'S';
340:

Line 382: From wsh_delivery_details

378: AND delete_mark = 0;
379:
380: CURSOR check_open_del IS
381: Select count(*)
382: From wsh_delivery_details
383: Where move_order_line_id = l_mo_line_rec.line_id
384: And source_line_id = l_mo_line_rec.txn_source_line_id
385: And released_status = 'S';
386:

Line 419: From wsh_delivery_details

415: -- AND NVL(sts.order_proc_ind,1)=1 PK Bug 3470116
416: AND NVL(sts.rejected_ind,0) = 0
417: AND trans.line_detail_id in
418: (Select delivery_detail_id
419: From wsh_delivery_details
420: Where move_order_line_id = p_mo_line_id
421: and released_status in ('R','S'))
422: ;
423:

Line 1392: From wsh_delivery_details

1388:
1389: IF l_mo_line_rec.quantity_delivered < l_mo_line_rec.quantity THEN
1390: Select count(*)
1391: INTO l_count
1392: From wsh_delivery_details
1393: Where move_order_line_id = l_mo_line_rec.line_id
1394: And source_line_id = l_mo_line_rec.txn_source_line_id
1395: And released_status = 'S';
1396: IF l_count = 0 THEN

Line 1726: FROM wsh_delivery_details

1722: WHERE line_id = p_line_id;
1723:
1724: CURSOR c_source_line IS
1725: SELECT source_line_id
1726: FROM wsh_delivery_details
1727: WHERE move_order_line_id = p_line_id;
1728:
1729: BEGIN
1730:

Line 1843: FROM wsh_delivery_details

1839: organization_id,
1840: requested_quantity_uom,
1841: requested_quantity_uom2,
1842: ship_tolerance_above
1843: FROM wsh_delivery_details
1844: WHERE source_line_id = x_source_line_id
1845: AND source_code = 'OE'
1846: AND container_flag = 'N'
1847: AND rownum = 1;

Line 1856: FROM wsh_delivery_details

1852: SELECT NVL(SUM(requested_quantity), 0) net_requested_qty,
1853: NVL(SUM(NVL(picked_quantity, requested_quantity)), 0) net_staged_qty,
1854: NVL(SUM(NVL(requested_quantity2,0)), 0) net_requested_qty2,
1855: NVL(SUM(NVL(picked_quantity2, requested_quantity2)), 0) net_staged_qty2
1856: FROM wsh_delivery_details
1857: WHERE source_line_id = x_source_line_id
1858: AND source_code = 'OE'
1859: AND container_flag = 'N'
1860: AND released_status IN ('X', 'Y', 'C');

Line 2533: FROM wsh_delivery_details

2529: AND completed_ind = 0;
2530:
2531: CURSOR tot_bkordr_qty_CUR IS
2532: SELECT sum(requested_quantity), sum(requested_quantity2)
2533: FROM wsh_delivery_details
2534: WHERE released_status = 'B'
2535: AND source_line_id = p_mo_line_rec.txn_source_line_id;
2536:
2537: -- HW BUG# 3871662: Issue:Cursor check_wsh violated the standards.