APPS.INV_GMI_MIGRATION dependencies on IC_ITEM_MST_B

Line 48: | Modified the update of ic_item_mst_b_mig based on item_id |

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 |

Line 81: | ic_item_mst_b_mig is not based on organization_id |

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 |

Line 128: FROM ic_item_mst_b

124:
125: BEGIN
126: SELECT item_no ||'('||to_char(p_item_id)||')'
127: INTO l_return_val
128: FROM ic_item_mst_b
129: WHERE item_id = p_item_id;
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN
132: G_msg_item_no := '('||to_char(p_item_id)||')';

Line 640: ic_item_mst_b_mig i,

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

Line 703: ic_item_mst_b_mig i

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

Line 742: UPDATE ic_item_mst_b_mig mig

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)

Line 750: /* UPDATE ic_item_mst_b_mig

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

Line 2307: FROM ic_loct_inv l ,ic_item_mst_b itm

2303: CURSOR c_ic_loct_inv IS
2304: SELECT l.rowid, l.*,itm.loct_ctl item_loct_ctl,
2305: itm.item_um, itm.lot_ctl,
2306: itm.noninv_ind, itm.item_no
2307: FROM ic_loct_inv l ,ic_item_mst_b itm
2308: WHERE l.migrated_ind is NULL
2309: AND ROUND(l.loct_onhand, 5) <> 0
2310: AND l.delete_mark = 0
2311: AND l.rowid between p_start_rowid and p_end_rowid

Line 2594: FROM ic_item_mst_b

2590: /* Commeted following code and joind ic_item table to
2591: main cursor for performance
2592: SELECT loct_ctl, item_um, lot_ctl, noninv_ind, item_no
2593: INTO l_item_loct_ctl, l_item_um, l_lot_ctl, l_noninv_ind, l_item_no
2594: FROM ic_item_mst_b
2595: WHERE
2596: item_id = bal.item_id;
2597: */
2598: IF (bal.noninv_ind = 1) THEN