APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_SYSTEM_ITEMS_B

Line 362: FROM mtl_system_items_b

358: l_action := 'I';
359:
360: SELECT inventory_item_id
361: INTO l_inventory_item_id
362: FROM mtl_system_items_b
363: WHERE
364: segment1 = l_opm_item.item_no and
365: ROWNUM = 1;
366:

Line 1849: t.table_name = 'MTL_SYSTEM_ITEMS_B' AND

1845: INTO l_count
1846: FROM fnd_tables t, fnd_columns c
1847: WHERE
1848: t.application_id = 401 AND
1849: t.table_name = 'MTL_SYSTEM_ITEMS_B' AND
1850: t.application_id = c.application_id AND
1851: t.table_id = c.table_id AND
1852: c.flexfield_application_id = 401 AND
1853: c.flexfield_name = 'MTL_SYSTEM_ITEMS' AND

Line 1953: UPDATE mtl_system_items_b

1949: INTO l_obsolete_column_value
1950: FROM dual
1951: WHERE rownum = 1;
1952:
1953: UPDATE mtl_system_items_b
1954: SET
1955: ATTRIBUTE1 = DECODE (p_flexfield_column_name, 'ATTRIBUTE1', l_obsolete_column_value, ATTRIBUTE1),
1956: ATTRIBUTE2 = DECODE (p_flexfield_column_name, 'ATTRIBUTE2', l_obsolete_column_value, ATTRIBUTE2),
1957: ATTRIBUTE3 = DECODE (p_flexfield_column_name, 'ATTRIBUTE3', l_obsolete_column_value, ATTRIBUTE3),