APPS.INV_OPM_ITEM_MIGRATION dependencies on MTL_SYSTEM_ITEMS_S

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