DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on WMS_LPN_CONTENTS

Line 264: FROM wms_lpn_contents wlc

260: AND (p_lpn_id IS NULL
261: OR (p_lpn_id IS NOT NULL
262: AND EXISTS(
263: SELECT wlc.parent_lpn_id
264: FROM wms_lpn_contents wlc
265: WHERE wlc.inventory_item_id = prl.item_id
266: AND wlc.parent_lpn_id IN(
267: SELECT lpn_id
268: FROM wms_license_plate_numbers

Line 334: FROM wms_lpn_contents wlc

330: AND (p_lpn_id IS NULL
331: OR(p_lpn_id IS NOT NULL
332: AND EXISTS(
333: SELECT wlc.parent_lpn_id
334: FROM wms_lpn_contents wlc
335: WHERE wlc.inventory_item_id = rsl.item_id
336: AND wlc.parent_lpn_id IN(
337: SELECT lpn_id
338: FROM wms_license_plate_numbers

Line 348: FROM wms_lpn_contents wlc,

344: )
345:
346: /* AND rsl.item_id IN (
347: SELECT wlc.inventory_item_id
348: FROM wms_lpn_contents wlc,
349: po_lines_all pol
350: WHERE pol.item_id = wlc.inventory_item_id
351: AND parent_lpn_id =
352: NVL ( p_lpn_id, parent_lpn_id )