DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_ITEM_REVISIONS

Line 564: FROM mtl_item_revisions

560: END IF;
561:
562: SELECT count(1)
563: INTO l_count
564: FROM mtl_item_revisions
565: WHERE inventory_item_id = l_item.inventory_item_id
566: AND organization_id = l_org.organization_id
567: AND revision = p_line_rec_tbl(i).odm_item_revision
568: AND implementation_date IS NOT NULL;