APPS.WMS_PUTAWAY_UTILS dependencies on WMS_LPN_CONTENTS

Line 3218: FROM wms_lpn_contents

3214: BEGIN -- Check Whether contents exists for this lpn
3215: l_progress := '30';
3216: SELECT 1
3217: INTO l_has_contents
3218: FROM wms_lpn_contents
3219: WHERE parent_lpn_id = l_lpn_id_tab(i)
3220: AND ROWNUM < 2;
3221: l_progress := '31';
3222:

Line 6628: FROM wms_lpn_contents

6624:
6625: BEGIN
6626: SELECT 'Y','Y'
6627: INTO l_content_lpn,l_lpn_has_contents
6628: FROM wms_lpn_contents
6629: WHERE parent_lpn_id = p_lpn_id
6630: AND ROWNUM<2;
6631: EXCEPTION
6632: WHEN no_data_found THEN

Line 6673: FROM wms_lpn_contents

6669: -- Start of code fix for bug 14723445
6670: IF x_loaded_status = 'Y' THEN
6671: BEGIN
6672: FOR x IN (SELECT Sum(primary_quantity) wlc_qty,inventory_item_id,organization_id
6673: FROM wms_lpn_contents
6674: WHERE parent_lpn_id = p_lpn_id AND organization_id = p_org_id
6675: GROUP BY inventory_item_id,organization_id) LOOP
6676: l_mmtt_qty := 0;
6677: SELECT Sum(mmtt.primary_quantity) INTO l_mmtt_qty

Line 6835: FROM wms_lpn_contents

6831: -- Check lpn has contents
6832: BEGIN
6833: SELECT 'Y','Y'
6834: INTO l_content_lpn,l_lpn_has_contents
6835: FROM wms_lpn_contents
6836: WHERE parent_lpn_id = l_lpn_id
6837: AND ROWNUM<2;
6838: EXCEPTION
6839: WHEN no_data_found THEN

Line 7083: FROM wms_lpn_contents

7079: EXIT WHEN lpn_cursor%notfound;
7080: -- Check if the given LPN has contents.
7081: BEGIN
7082: SELECT 'Y' INTO l_is_content_lpn
7083: FROM wms_lpn_contents
7084: WHERE parent_lpn_id = l_lpn_id
7085: AND ROWNUM<2;
7086: EXCEPTION
7087: WHEN no_data_found THEN l_is_content_lpn := 'N';

Line 7146: wms_lpn_contents wlc

7142: select count(1) INTO l_wlc_without_mmtt from
7143: (SELECT lpn_id FROM wms_license_plate_numbers
7144: START WITH lpn_id = p_lpn_id
7145: CONNECT BY PRIOR lpn_id = parent_lpn_id ) wlpn ,
7146: wms_lpn_contents wlc
7147: where
7148: wlc.parent_lpn_id = wlpn.lpn_id
7149: and not exists (select 1 from mtl_material_transactions_temp mmtt
7150: where mmtt.organization_id = wlc.organization_id

Line 8805: wms_lpn_contents wlpnc, mtl_system_items msi

8801: ,wlpnc.secondary_uom_code -- Added for Bug 10301152
8802: ,msi.serial_number_control_code
8803: ,msi.primary_uom_code
8804: FROM
8805: wms_lpn_contents wlpnc, mtl_system_items msi
8806: WHERE
8807: wlpnc.parent_lpn_id = p_from_lpn_id
8808: AND wlpnc.inventory_item_id = msi.inventory_item_id
8809: AND wlpnc.organization_id = msi.organization_id;

Line 9197: FROM wms_lpn_contents

9193:
9194: BEGIN
9195: SELECT COUNT(lpn_content_id)
9196: INTO l_count
9197: FROM wms_lpn_contents
9198: WHERE parent_lpn_id = p_from_lpn_id;
9199: EXCEPTION
9200: WHEN no_data_found THEN
9201: l_count := 0;

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

12465:
12466: BEGIN
12467: -- Validate the LPN
12468: -- Bug 4652943
12469: -- For Performance Reason the count for WMS_LPN_CONTENTS
12470: -- is done outside.
12471:
12472: l_lpn_has_material := 0;
12473:

Line 12476: FROM wms_lpn_contents

12472: l_lpn_has_material := 0;
12473:
12474: select NVL(count(1),0)
12475: into l_lpn_has_material
12476: FROM wms_lpn_contents
12477: WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id
12478: FROM wms_license_plate_numbers wlpn1
12479: START WITH wlpn1.lpn_id = l_into_outermost_lpn_id
12480: CONNECT BY PRIOR wlpn1.lpn_id = wlpn1.parent_lpn_id);

Line 12496: --FROM wms_lpn_contents

12492: OR (wlpn.lpn_context = l_lpn_context
12493: AND (
12494: ( l_lpn_has_material = 0
12495: --NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'
12496: --FROM wms_lpn_contents
12497: --WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id
12498: -- FROM wms_license_plate_numbers wlpn1
12499: -- START WITH wlpn1.lpn_id = wlpn.outermost_lpn_id
12500: -- CONNECT BY PRIOR wlpn1.lpn_id = wlpn1.parent_lpn_id)

Line 12843: from wms_lpn_contents

12839: and row_type = 'Group Task'
12840: and drop_type = 'ID';
12841:
12842: select sum(primary_quantity) into l_qty_wlc --12679402
12843: from wms_lpn_contents
12844: where parent_lpn_id = p_lpn_id;
12845:
12846: IF (l_qty_gtmp<>l_qty_wlc) THEN
12847: IF (l_debug = 1) THEN

Line 13352: wms_lpn_contents

13348: SELECT
13349: parent_lpn_id lpn_id,
13350: inventory_item_id
13351: FROM
13352: wms_lpn_contents
13353: WHERE
13354: parent_lpn_id IN
13355: (
13356: SELECT

Line 13399: wms_lpn_contents

13395: NVL(SUM(quantity),0) wlc_quantity ,
13396: inventory_item_id,
13397: uom_code
13398: FROM
13399: wms_lpn_contents
13400: WHERE
13401: parent_lpn_id IN
13402: (
13403: SELECT

Line 13426: wms_lpn_contents wlc

13422: IS
13423: SELECT
13424: 1
13425: FROM
13426: wms_lpn_contents wlc
13427: WHERE
13428: parent_lpn_id IN
13429: (
13430: SELECT

Line 13484: wms_lpn_contents wlc

13480: SELECT
13481: 1
13482: FROM
13483: mtl_txn_request_lines mtrl,
13484: wms_lpn_contents wlc
13485: WHERE
13486: mtrl.lpn_id = wlc.parent_lpn_id
13487: AND mtrl.lot_number IS NOT NULL
13488: AND wlc.lot_number IS NOT NULL

Line 13676: wms_lpn_contents

13672: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
13673: --Updating WLC and Deleting RTI manually as we are not doing it as part of
13674: -- cancel_operation_plan call
13675: UPDATE
13676: wms_lpn_contents
13677: SET
13678: source_name = NULL,
13679: source_header_id =NULL,
13680: last_updated_by = l_user_id,

Line 14011: wms_lpn_contents

14007: (
14008: SELECT
14009: lot_number
14010: FROM
14011: wms_lpn_contents
14012: WHERE
14013: parent_lpn_id IN (p_lpn_id)
14014: );
14015: --delete RLI

Line 14140: wms_lpn_contents

14136: AND line_status = 7
14137: AND quantity-NVL(quantity_delivered,0) > 0
14138: );
14139: UPDATE
14140: wms_lpn_contents
14141: SET
14142: source_header_id = NULL,
14143: source_name = NULL
14144: WHERE

Line 14824: FROM wms_lpn_contents

14820: -- Check lpn has contents
14821: BEGIN
14822: SELECT 'Y','Y'
14823: INTO l_content_lpn,l_lpn_has_contents
14824: FROM wms_lpn_contents
14825: WHERE parent_lpn_id = l_lpn_id
14826: AND ROWNUM<2;
14827: EXCEPTION
14828: WHEN no_data_found THEN