APPS.INV_GMI_MIGRATION dependencies on IC_ITEM_MST_B

Line 89: FROM ic_item_mst_b

85:
86: BEGIN
87: SELECT item_no ||'('||to_char(p_item_id)||')'
88: INTO l_return_val
89: FROM ic_item_mst_b
90: WHERE item_id = p_item_id;
91: EXCEPTION
92: WHEN NO_DATA_FOUND THEN
93: G_msg_item_no := '('||to_char(p_item_id)||')';

Line 601: ic_item_mst_b_mig i,

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

Line 664: ic_item_mst_b_mig i

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

Line 701: UPDATE ic_item_mst_b_mig

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

Line 2479: FROM ic_item_mst_b

2475: l_field_value := 'OPM item id = '||to_char(bal.item_id);
2476:
2477: SELECT loct_ctl, item_um, lot_ctl, noninv_ind, item_no
2478: INTO l_item_loct_ctl, l_item_um, l_lot_ctl, l_noninv_ind, l_item_no
2479: FROM ic_item_mst_b
2480: WHERE
2481: item_id = bal.item_id;
2482:
2483: IF (l_noninv_ind = 1) THEN