DBA Data[Home] [Help]

APPS.INV_COMINGLING_UTILS dependencies on WMS_LPN_CONTENTS

Line 435: ** Look at WMS_LPN_CONTENTS, lpn content details table

431: END IF;
432:
433: else /* LPN transaction */
434: /*
435: ** Look at WMS_LPN_CONTENTS, lpn content details table
436: */
437:
438: BEGIN
439: SELECT 'Y' INTO l_lpn_contents_exist

Line 449: from wms_lpn_contents

445: --Changing the count(*) to existence for performance improvement
446: --select
447: --count(*)
448: --into l_lpn_contents_count
449: from wms_lpn_contents
450: where organization_id = p_organization_id
451: AND inventory_item_id = p_inventory_item_id
452: AND (revision = p_revision
453: OR revision is null and p_revision is null)