DBA Data[Home] [Help]

APPS.EAM_REBUILDS_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 145: from mtl_object_genealogy

141: and cii.inventory_item_id = msn.inventory_item_id
142: and cii.last_vld_organization_id = msn.current_organization_id;
143:
144: select object_id into l_dummy_num
145: from mtl_object_genealogy
146: where object_id = l_object_id
147: and parent_object_id = l_parent_object_id
148: and start_date_active <= sysdate
149: and (end_date_active is null or end_date_active >= sysdate);