DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_ITEM_REVISIONS

Line 571: FROM mtl_item_revisions

567: END IF;
568:
569: SELECT count(1)
570: INTO l_count
571: FROM mtl_item_revisions
572: WHERE inventory_item_id = l_item.inventory_item_id
573: AND organization_id = l_org.organization_id
574: AND revision = p_line_rec_tbl(i).odm_item_revision
575: AND implementation_date IS NOT NULL;