APPS.WMS_PUTAWAY_UTILS dependencies on WMS_LPN_CONTENTS

Line 2573: FROM wms_lpn_contents

2569: BEGIN -- Check Whether contents exists for this lpn
2570: l_progress := '30';
2571: SELECT 1
2572: INTO l_has_contents
2573: FROM wms_lpn_contents
2574: WHERE parent_lpn_id = l_lpn_id_tab(i)
2575: AND ROWNUM < 2;
2576: l_progress := '31';
2577:

Line 5896: FROM wms_lpn_contents

5892:
5893: BEGIN
5894: SELECT 'Y','Y'
5895: INTO l_content_lpn,l_lpn_has_contents
5896: FROM wms_lpn_contents
5897: WHERE parent_lpn_id = p_lpn_id
5898: AND ROWNUM<2;
5899: EXCEPTION
5900: WHEN no_data_found THEN

Line 6024: FROM wms_lpn_contents

6020: -- Check lpn has contents
6021: BEGIN
6022: SELECT 'Y','Y'
6023: INTO l_content_lpn,l_lpn_has_contents
6024: FROM wms_lpn_contents
6025: WHERE parent_lpn_id = l_lpn_id
6026: AND ROWNUM<2;
6027: EXCEPTION
6028: WHEN no_data_found THEN

Line 6254: FROM wms_lpn_contents

6250: EXIT WHEN lpn_cursor%notfound;
6251: -- Check if the given LPN has contents.
6252: BEGIN
6253: SELECT 'Y' INTO l_is_content_lpn
6254: FROM wms_lpn_contents
6255: WHERE parent_lpn_id = l_lpn_id
6256: AND ROWNUM<2;
6257: EXCEPTION
6258: WHEN no_data_found THEN l_is_content_lpn := 'N';

Line 7941: wms_lpn_contents wlpnc, mtl_system_items msi

7937: ,wlpnc.uom_code
7938: ,msi.serial_number_control_code
7939: ,msi.primary_uom_code
7940: FROM
7941: wms_lpn_contents wlpnc, mtl_system_items msi
7942: WHERE
7943: wlpnc.parent_lpn_id = p_from_lpn_id
7944: AND wlpnc.inventory_item_id = msi.inventory_item_id
7945: AND wlpnc.organization_id = msi.organization_id;

Line 8332: FROM wms_lpn_contents

8328:
8329: BEGIN
8330: SELECT COUNT(lpn_content_id)
8331: INTO l_count
8332: FROM wms_lpn_contents
8333: WHERE parent_lpn_id = p_from_lpn_id;
8334: EXCEPTION
8335: WHEN no_data_found THEN
8336: l_count := 0;

Line 11490: -- For Performance Reason the count for WMS_LPN_CONTENTS

11486:
11487: BEGIN
11488: -- Validate the LPN
11489: -- Bug 4652943
11490: -- For Performance Reason the count for WMS_LPN_CONTENTS
11491: -- is done outside.
11492:
11493: l_lpn_has_material := 0;
11494:

Line 11497: FROM wms_lpn_contents

11493: l_lpn_has_material := 0;
11494:
11495: select NVL(count(1),0)
11496: into l_lpn_has_material
11497: FROM wms_lpn_contents
11498: WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id
11499: FROM wms_license_plate_numbers wlpn1
11500: START WITH wlpn1.lpn_id = l_into_outermost_lpn_id
11501: CONNECT BY PRIOR wlpn1.lpn_id = wlpn1.parent_lpn_id);

Line 11517: --FROM wms_lpn_contents

11513: OR (wlpn.lpn_context = l_lpn_context
11514: AND (
11515: ( l_lpn_has_material = 0
11516: --NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'
11517: --FROM wms_lpn_contents
11518: --WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id
11519: -- FROM wms_license_plate_numbers wlpn1
11520: -- START WITH wlpn1.lpn_id = wlpn.outermost_lpn_id
11521: -- CONNECT BY PRIOR wlpn1.lpn_id = wlpn1.parent_lpn_id)

Line 11742: from wms_lpn_contents

11738: and row_type = 'Group Task'
11739: and drop_type = 'ID';
11740:
11741: select sum(quantity) into l_qty_wlc
11742: from wms_lpn_contents
11743: where parent_lpn_id = p_lpn_id;
11744:
11745: IF (l_qty_gtmp<>l_qty_wlc) THEN
11746: IF (l_debug = 1) THEN

Line 12691: FROM wms_lpn_contents

12687: -- Check lpn has contents
12688: BEGIN
12689: SELECT 'Y','Y'
12690: INTO l_content_lpn,l_lpn_has_contents
12691: FROM wms_lpn_contents
12692: WHERE parent_lpn_id = l_lpn_id
12693: AND ROWNUM<2;
12694: EXCEPTION
12695: WHEN no_data_found THEN