APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 334: FROM mtl_system_items_b

330: l_action := 'I';
331:
332: SELECT inventory_item_id
333: INTO l_inventory_item_id
334: FROM mtl_system_items_b
335: WHERE
336: segment1 = l_opm_item.item_no and
337: ROWNUM = 1;
338:

Line 1751: t.table_name = 'MTL_SYSTEM_ITEMS_B' AND

1747: INTO l_count
1748: FROM fnd_tables t, fnd_columns c
1749: WHERE
1750: t.application_id = 401 AND
1751: t.table_name = 'MTL_SYSTEM_ITEMS_B' AND
1752: t.application_id = c.application_id AND
1753: t.table_id = c.table_id AND
1754: c.flexfield_application_id = 401 AND
1755: c.flexfield_name = 'MTL_SYSTEM_ITEMS' AND

Line 1855: UPDATE mtl_system_items_b

1851: INTO l_obsolete_column_value
1852: FROM dual
1853: WHERE rownum = 1;
1854:
1855: UPDATE mtl_system_items_b
1856: SET
1857: ATTRIBUTE1 = DECODE (p_flexfield_column_name, 'ATTRIBUTE1', l_obsolete_column_value, ATTRIBUTE1),
1858: ATTRIBUTE2 = DECODE (p_flexfield_column_name, 'ATTRIBUTE2', l_obsolete_column_value, ATTRIBUTE2),
1859: ATTRIBUTE3 = DECODE (p_flexfield_column_name, 'ATTRIBUTE3', l_obsolete_column_value, ATTRIBUTE3),