APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 586: and EXISTS (select secondary_inventory from mtl_item_sub_inventories

582: secondary_inventory_name = p_eam_wo_comp_rec.completion_subinventory
583: and organization_id = l_org_id
584: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
585: and Asset_inventory = 2
586: and EXISTS (select secondary_inventory from mtl_item_sub_inventories
587: where secondary_inventory = secondary_inventory_name
588: and inventory_item_id = l_inventory_item_id
589: and organization_id = l_org_id);
590: end if;