APPS.INV_OPM_ITEM_MIGRATION dependencies on IC_ITEM_MST_B_MIG

Line 874: UPDATE ic_item_mst_b_mig

870: language = d.language;
871: END LOOP;
872:
873: -- Bug 5489195 - Added migrated_ind in the update
874: UPDATE ic_item_mst_b_mig
875: SET
876: inventory_item_id = x_inventory_item_id,
877: migrated_ind = 1,
878: last_update_date = sysdate,

Line 885: INSERT INTO ic_item_mst_b_mig(

881: item_id = p_item_id AND
882: organization_id = p_organization_id;
883:
884: IF SQL%ROWCOUNT = 0 THEN
885: INSERT INTO ic_item_mst_b_mig(
886: item_id,
887: organization_id,
888: inventory_item_id,
889: migrated_ind,

Line 1342: -- for GMI items check the value in ic_item_mst_b_mig table

1338: x_failure_count := x_failure_count + 1;
1339: RETURN;
1340: END IF;
1341:
1342: -- for GMI items check the value in ic_item_mst_b_mig table
1343: IF (p_item_source = 'GMI') THEN
1344: BEGIN
1345: g_item_id := p_item_id;
1346: g_organization_id := p_organization_id;

Line 1354: FROM ic_item_mst_b_mig

1350: -- Select and lock the row to avoid errors associated with running this routine in
1351: -- parallel from routines using AD parrallel update logic.
1352: SELECT inventory_item_id, migrated_ind
1353: INTO g_inventory_item_id, l_migrated_ind
1354: FROM ic_item_mst_b_mig
1355: WHERE
1356: item_id = g_item_id AND
1357: organization_id = g_organization_id
1358: FOR UPDATE;

Line 1368: INSERT INTO ic_item_mst_b_mig(

1364: END IF;
1365: EXCEPTION
1366: WHEN NO_DATA_FOUND THEN
1367: BEGIN
1368: INSERT INTO ic_item_mst_b_mig(
1369: item_id,
1370: organization_id,
1371: inventory_item_id,
1372: migrated_ind,

Line 1397: FROM ic_item_mst_b_mig

1393:
1394: -- Lock this row for the parrallel run of this routine.
1395: SELECT 1
1396: INTO dv
1397: FROM ic_item_mst_b_mig
1398: WHERE
1399: item_id = g_item_id AND
1400: organization_id = g_organization_id
1401: FOR UPDATE;

Line 1420: FROM ic_item_mst_b_mig i

1416: -- Select and lock the row to avoid errors associated with running this routine in
1417: -- parallel from routines using AD parrallel update logic.
1418: SELECT i.migrated_ind
1419: INTO l_migrated_ind_m
1420: FROM ic_item_mst_b_mig i
1421: WHERE
1422: i.organization_id = l_master_organization_id and
1423: i.item_id = p_item_id
1424: FOR UPDATE;

Line 1430: INSERT INTO ic_item_mst_b_mig(

1426: WHEN NO_DATA_FOUND THEN
1427: -- Jatinder - 11/30/06 - Use correct organization to lock migration records. 5690686.
1428: IF (p_item_source = 'GMI') THEN
1429: BEGIN
1430: INSERT INTO ic_item_mst_b_mig(
1431: item_id,
1432: organization_id,
1433: inventory_item_id,
1434: migrated_ind,

Line 1459: FROM ic_item_mst_b_mig

1455:
1456: -- Lock this row for the parrallel run of this routine.
1457: SELECT 1
1458: INTO dv
1459: FROM ic_item_mst_b_mig
1460: WHERE
1461: item_id = p_item_id AND
1462: organization_id = l_master_organization_id
1463: FOR UPDATE;

Line 1646: FROM ic_item_mst_b i, ic_item_mst_b_mig m

1642: CURSOR c_item IS
1643: SELECT m.organization_id, m.inventory_item_id, i.alt_itema,
1644: i.alt_itemb, i.match_type, i.upc_code, i.qcitem_id,
1645: i.qchold_res_code
1646: FROM ic_item_mst_b i, ic_item_mst_b_mig m
1647: WHERE
1648: i.item_id = m.item_id AND
1649: m.migrated_ind = 1;
1650: