eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_SYSTEM_ITEMS

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 423: SELECT mtl_system_items_s.nextval

419:
420: -- Added for Bug 14558263.
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: SELECT mtl_system_items_s.nextval
424: INTO l_inventory_item_id
425: FROM dual
426: WHERE rownum = 1;
427: END;

Line 948: UPDATE mtl_system_items_tl

944: IF p_item_source = 'GMI' THEN
945:
946: -- Update the item description in the TL tables.
947: FOR d in c_ic_item_mst_tl LOOP
948: UPDATE mtl_system_items_tl
949: SET description = d.item_desc1,
950: long_description = nvl(long_description, d.item_desc2),
951: source_lang = d.source_lang,
952: last_update_date = d.last_update_date,

Line 1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',

1104: CURSOR c_master_attributes IS
1105: SELECT attribute_name FROM mtl_item_attributes
1106: WHERE
1107: control_level = 1 AND
1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',

Line 1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',

1105: SELECT attribute_name FROM mtl_item_attributes
1106: WHERE
1107: control_level = 1 AND
1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',

Line 1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',

1106: WHERE
1107: control_level = 1 AND
1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',

Line 1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',

1107: control_level = 1 AND
1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',

Line 1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',

1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',

Line 1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',

1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',

Line 1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',

1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',

Line 1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',

1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',

Line 1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',

1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',
1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',

Line 1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',

1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',
1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND

Line 1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',

1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',
1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND
1122: EXISTS (

Line 1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',

1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',
1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND
1122: EXISTS (
1123: SELECT 1

Line 1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',

1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',
1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND
1122: EXISTS (
1123: SELECT 1
1124: FROM mtl_parameters mo, mtl_parameters co

Line 1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND

1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1118: 'MTL_SYSTEM_ITEMS.LOCATION_CONTROL_CODE',
1119: 'MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE',
1120: 'MTL_SYSTEM_ITEMS.LOT_STATUS_ENABLED',
1121: 'MTL_SYSTEM_ITEMS.START_AUTO_LOT_NUMBER') AND
1122: EXISTS (
1123: SELECT 1
1124: FROM mtl_parameters mo, mtl_parameters co
1125: WHERE

Line 1193: col2.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and

1189: FROM fnd_descr_flex_column_usages col2,
1190: fnd_descr_flex_contexts cont2
1191: WHERE
1192: col2.application_id = 401 and
1193: col2.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and
1194: col2.enabled_flag = 'Y' and
1195: col.application_id = cont2.application_id and
1196: col.descriptive_flexfield_name = cont2.descriptive_flexfield_name and
1197: col.descriptive_flex_context_code = cont2.descriptive_flex_context_code and

Line 1240: cont.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and

1236: SELECT cont.descriptive_flex_context_code
1237: INTO l_odm_context
1238: FROM fnd_descr_flex_contexts cont
1239: WHERE cont.application_id = 401 and
1240: cont.descriptive_flexfield_name = 'MTL_SYSTEM_ITEMS' and
1241: cont.enabled_flag = 'Y' and
1242: cont.global_flag = 'N' and
1243: rownum = 1;
1244: EXCEPTION

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 1853: c.flexfield_name = 'MTL_SYSTEM_ITEMS' 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
1854: c.flexfield_usage_code = 'D' AND
1855: c.column_name = p_flexfield_column_name;
1856: EXCEPTION
1857: WHEN NO_DATA_FOUND THEN

Line 1884: col2.descriptive_flexfield_name in ('MTL_SYSTEM_ITEMS', 'ITEM_FLEX') AND

1880: FROM fnd_descr_flex_column_usages col2,
1881: fnd_descr_flex_contexts cont2
1882: WHERE
1883: col2.application_id IN (401, 551) and
1884: col2.descriptive_flexfield_name in ('MTL_SYSTEM_ITEMS', 'ITEM_FLEX') AND
1885: col2.enabled_flag = 'Y' and
1886: col2.application_id = cont2.application_id and
1887: col2.descriptive_flexfield_name = cont2.descriptive_flexfield_name and
1888: col2.descriptive_flex_context_code = cont2.descriptive_flex_context_code and

Line 1916: flexfield_name => 'MTL_SYSTEM_ITEMS',

1912: -- Update flexfield definition
1913: fnd_flex_dsc_api.set_session_mode ('customer_data');
1914: fnd_flex_dsc_api.create_segment(
1915: appl_short_name => 'INV',
1916: flexfield_name => 'MTL_SYSTEM_ITEMS',
1917: context_name => 'Global Data Elements',
1918: name => p_obsolete_column_name,
1919: column => p_flexfield_column_name,
1920: description => p_obsolete_column_name,

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),

Line 2086: from mtl_system_items a,

2082:
2083: select a.inventory_item_id ,
2084: a.organization_id ,
2085: a.segment1 item_no
2086: from mtl_system_items a,
2087: mtl_parameters b
2088: where a.organization_id = b.organization_id
2089: and b.process_enabled_flag = 'Y'
2090: and b.organization_code = p_organization_code