597: i.inventory_item_id,
598: i.organization_id,
599: g.category_set_id
600: FROM gmi_item_categories g,
601: ic_item_mst_b_mig i,
602: mtl_item_categories m
603: WHERE g.rowid BETWEEN p_start_rowid AND p_end_rowid AND
604: i.migrated_ind is not NULL and
605: i.category_migrated_ind is NULL and
660: NULL,
661: NULL,
662: NULL
663: FROM gmi_item_categories g,
664: ic_item_mst_b_mig i
665: WHERE g.rowid BETWEEN p_start_rowid AND p_end_rowid AND
666: i.migrated_ind is not NULL and
667: i.category_migrated_ind is NULL and
668: i.item_id = g.item_id and
697: END LOOP;
698:
699:
700: /* Update the rows as migrated */
701: UPDATE ic_item_mst_b_mig
702: SET category_migrated_ind = 1
703: WHERE
704: (organization_id, inventory_item_id) IN (
705: SELECT organization_id, inventory_item_id