DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 674: and EXISTS (select secondary_inventory from mtl_item_sub_inventories

670: secondary_inventory_name = p_subinventory
671: and organization_id = p_org_id
672: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
673: and Asset_inventory = 2
674: and EXISTS (select secondary_inventory from mtl_item_sub_inventories
675: where secondary_inventory = secondary_inventory_name
676: and inventory_item_id = p_item_id
677: and organization_id = p_org_id);
678: end if;