DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on WMS_LPN_CONTENTS

Line 262: FROM wms_lpn_contents wlc

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

Line 332: FROM wms_lpn_contents wlc

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

Line 346: FROM wms_lpn_contents wlc,

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