APPS.WMS_ITEM_LOAD dependencies on WMS_LPN_CONTENTS

Line 163: FROM wms_lpn_contents

159: NULL
160: )
161: ))
162: INTO x_total_qty
163: FROM wms_lpn_contents
164: WHERE inventory_item_id = p_inventory_item_id
165: AND organization_id = p_organization_id
166: AND parent_lpn_id = p_lpn_id
167: AND Nvl(revision,'#$%') = Nvl(p_revision,'#$%');

Line 420: -- Variables used to lock the WLC (WMS_LPN_CONTENTS) records.

416: l_api_name CONSTANT VARCHAR2(30) := 'pre_process_load';
417: l_progress VARCHAR2(10);
418: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
419: l_lpn_context NUMBER;
420: -- Variables used to lock the WLC (WMS_LPN_CONTENTS) records.
421: -- WLC records should always exist for the given LPN if an item
422: -- load on the java side has been done.
423: CURSOR lock_wlc_cursor IS
424: SELECT lpn_content_id

Line 425: FROM wms_lpn_contents

421: -- WLC records should always exist for the given LPN if an item
422: -- load on the java side has been done.
423: CURSOR lock_wlc_cursor IS
424: SELECT lpn_content_id
425: FROM wms_lpn_contents
426: WHERE parent_lpn_id = p_lpn_id
427: AND inventory_item_id = p_inventory_item_id
428: AND organization_id = p_organization_id
429: AND NVL(revision, '###') = NVL(p_revision, '###')

Line 836: FROM wms_lpn_contents

832: -- multiple WLC records for the same LPN/item/rev/lot which is possible
833: -- if from different sources.
834: SELECT DISTINCT NVL(cost_group_id, -999)
835: INTO l_cost_group_id
836: FROM wms_lpn_contents
837: WHERE parent_lpn_id = p_lpn_id
838: AND inventory_item_id = p_inventory_item_id
839: AND NVL(revision, '###') = NVL(p_revision, '###')
840: AND NVL(lot_number, '###') = NVL(p_lot_number, '###')