APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_LPN_CONTENTS

Line 1216: FROM wms_lpn_contents

1212: , revision
1213: , cost_group_id
1214: , secondary_quantity -- Added for OPM convergance
1215: , secondary_uom_code -- Added for OPM convergance
1216: FROM wms_lpn_contents
1217: WHERE parent_lpn_id = p_lpn_id;
1218:
1219: l_m_item NUMBER;
1220: l_m_qty NUMBER;

Line 1969: wms_lpn_contents

1965: revision,
1966: lot_number,
1967: organization_id--BUG 4607833
1968: FROM
1969: wms_lpn_contents
1970: GROUP BY parent_lpn_id, inventory_item_id, revision, lot_number,uom_code,organization_id--BUG 4607833
1971: ) wlc, -- sub-query is necessary because there could be more than one wlc record for the same inventory_item_id, revision, lot_number
1972: mtl_txn_request_lines mol
1973: WHERE wlc.parent_lpn_id = mol.lpn_id

Line 7200: FROM wms_lpn_contents

7196: BEGIN
7197: -- Check the LPN Content it should be null
7198: SELECT quantity
7199: INTO l_quantity
7200: FROM wms_lpn_contents
7201: WHERE parent_lpn_id = l_to_lpn_id
7202: AND ROWNUM < 2;
7203:
7204: --

Line 7768: FROM wms_lpn_contents

7764: , cost_group_id
7765: , parent_lpn_id
7766: , secondary_quantity --BUG12796808
7767: , secondary_uom_code --BUG12796808
7768: FROM wms_lpn_contents
7769: WHERE parent_lpn_id = l_current_lpn_id;
7770: BEGIN
7771: -- Intialize out variables
7772: x_return_status := fnd_api.g_ret_sts_success;

Line 8044: FROM wms_lpn_contents

8040: END IF;
8041:
8042: BEGIN
8043: SELECT 'Y' INTO l_is_content_lpn
8044: FROM wms_lpn_contents
8045: WHERE parent_lpn_id = l_lpn_id;
8046: EXCEPTION
8047: WHEN no_data_found THEN
8048: l_is_content_lpn := 'N';