APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_LPN_CONTENTS

Line 1078: FROM wms_lpn_contents

1074: , revision
1075: , cost_group_id
1076: , secondary_quantity -- Added for OPM convergance
1077: , secondary_uom_code -- Added for OPM convergance
1078: FROM wms_lpn_contents
1079: WHERE parent_lpn_id = p_lpn_id;
1080:
1081: l_m_item NUMBER;
1082: l_m_qty NUMBER;

Line 1824: wms_lpn_contents

1820: revision,
1821: lot_number,
1822: organization_id--BUG 4607833
1823: FROM
1824: wms_lpn_contents
1825: GROUP BY parent_lpn_id, inventory_item_id, revision, lot_number,uom_code,organization_id--BUG 4607833
1826: ) wlc, -- sub-query is necessary because there could be more than one wlc record for the same inventory_item_id, revision, lot_number
1827: mtl_txn_request_lines mol
1828: WHERE wlc.parent_lpn_id = mol.lpn_id

Line 6873: FROM wms_lpn_contents

6869: BEGIN
6870: -- Check the LPN Content it should be null
6871: SELECT quantity
6872: INTO l_quantity
6873: FROM wms_lpn_contents
6874: WHERE parent_lpn_id = l_to_lpn_id
6875: AND ROWNUM < 2;
6876:
6877: --

Line 7437: FROM wms_lpn_contents

7433: , lot_number
7434: , revision
7435: , cost_group_id
7436: , parent_lpn_id
7437: FROM wms_lpn_contents
7438: WHERE parent_lpn_id = l_current_lpn_id;
7439: BEGIN
7440: -- Intialize out variables
7441: x_return_status := fnd_api.g_ret_sts_success;

Line 7707: FROM wms_lpn_contents

7703: END IF;
7704:
7705: BEGIN
7706: SELECT 'Y' INTO l_is_content_lpn
7707: FROM wms_lpn_contents
7708: WHERE parent_lpn_id = l_lpn_id;
7709: EXCEPTION
7710: WHEN no_data_found THEN
7711: l_is_content_lpn := 'N';