44: | should be Disallowed. |
45: | Jatinder - 12/18/06- Bug 5722698. Added NVL to the |
46: | UPDATE_BATCH_INDICATOR column. |
47: | Archana Mundhe 08/12/2008 Bug 6845259 |
48: | Modified the update of ic_item_mst_b_mig based on item_id |
49: | Archana Mundhe 03/25/2009 Bug 8363586 |
50: | Modified migrate_inventory_balances to exclude records that|
51: | are delete marked from being processed. |
52: | Kedar Bavadekar - 06/23/09 |
77: | moved to GMI package where it was setting them to Y |
78: | Srinivasulu Puri - 3/30/2012 Bug#13910275 commented category migrated |
79: | ind check in migrate_item_category insert stmt |
80: | as category migration is parallel and update of |
81: | ic_item_mst_b_mig is not based on organization_id |
82: | Shaliu Chen - 06/05/2012 Bug#14147616 |
83: | Modify init_doc_seq procedure to add exception |
84: | handling program to ignore Duplicate Key on |
85: | Index error |
636: i.inventory_item_id,
637: i.organization_id,
638: g.category_set_id
639: FROM gmi_item_categories g,
640: ic_item_mst_b_mig i,
641: mtl_item_categories m
642: WHERE i.rowid BETWEEN p_start_rowid AND p_end_rowid AND
643: i.migrated_ind is not NULL and
644: i.category_migrated_ind is NULL and
699: NULL,
700: NULL,
701: NULL
702: FROM gmi_item_categories g,
703: ic_item_mst_b_mig i
704: WHERE i.rowid BETWEEN p_start_rowid AND p_end_rowid AND
705: i.migrated_ind is not NULL and
706: -- i.category_migrated_ind is NULL and bug 13910275
707: i.item_id = g.item_id and
738:
739: /* Update the rows as migrated */
740: /* Bug 6845259 */
741: /* Modified the update*/
742: UPDATE ic_item_mst_b_mig mig
743: SET category_migrated_ind = 1
744: WHERE exists ( SELECT 1
745: FROM gmi_item_categories gic
746: WHERE mig.item_id = gic.item_id)
746: WHERE mig.item_id = gic.item_id)
747: AND ROWID BETWEEN p_start_rowid AND p_end_rowid;
748:
749:
750: /* UPDATE ic_item_mst_b_mig
751: SET category_migrated_ind = 1
752: WHERE
753: (organization_id, inventory_item_id) IN (
754: SELECT organization_id, inventory_item_id