APPS.WMS_OPP_CYC_COUNT dependencies on WMS_LPN_CONTENTS

Line 1823: FROM wms_lpn_contents wlc, mtl_serial_numbers msn

1819:
1820: l_progress := '70';
1821:
1822: FOR lpn_contents_cur IN (SELECT DISTINCT wlc.inventory_item_id, wlc.lot_number, wlc.revision, DECODE(NVL(msn.serial_number, 'XXXX'), 'XXXX', wlc.primary_quantity, 1) primary_quantity, msn.serial_number
1823: FROM wms_lpn_contents wlc, mtl_serial_numbers msn
1824: WHERE wlc.parent_lpn_id=p_parent_lpn_id
1825: AND wlc.inventory_item_id = msn.inventory_item_id (+)
1826: AND ( msn.inventory_item_id IS NULL
1827: OR (msn.current_organization_id = p_organization_id

Line 1932: FROM wms_lpn_contents wlc

1928:
1929: END LOOP;
1930:
1931: FOR lpn_contents_cur IN (SELECT wlc.inventory_item_id, wlc.lot_number, wlc.revision, Sum(wlc.primary_quantity) primary_quantity
1932: FROM wms_lpn_contents wlc
1933: WHERE wlc.parent_lpn_id=p_parent_lpn_id
1934: GROUP BY wlc.inventory_item_id, wlc.lot_number, wlc.revision)
1935: LOOP
1936:

Line 2502: FROM wms_lpn_contents wlc, mtl_serial_numbers msn

2498:
2499: l_progress := '70';
2500:
2501: FOR lpn_contents_cur IN (SELECT DISTINCT wlc.inventory_item_id, wlc.lot_number, wlc.revision, DECODE(NVL(msn.serial_number, 'XXXX'), 'XXXX', wlc.primary_quantity, 1) primary_quantity, msn.serial_number
2502: FROM wms_lpn_contents wlc, mtl_serial_numbers msn
2503: WHERE wlc.parent_lpn_id=p_parent_lpn_id
2504: AND wlc.inventory_item_id = msn.inventory_item_id (+)
2505: AND ( msn.inventory_item_id IS NULL
2506: OR (msn.current_organization_id = p_organization_id

Line 2611: FROM wms_lpn_contents wlc

2607:
2608: END LOOP;
2609:
2610: FOR lpn_contents_cur IN (SELECT wlc.inventory_item_id, wlc.lot_number, wlc.revision, Sum(wlc.primary_quantity) primary_quantity
2611: FROM wms_lpn_contents wlc
2612: WHERE wlc.parent_lpn_id=p_parent_lpn_id
2613: GROUP BY wlc.inventory_item_id, wlc.lot_number, wlc.revision)
2614: LOOP
2615: