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.INVUPD1B dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 40: FROM mtl_system_items_interface intf

36: xset_id IN NUMBER DEFAULT -999) RETURN INTEGER IS
37:
38: CURSOR C_msii_records IS
39: SELECT ROWID, intf.*
40: FROM mtl_system_items_interface intf
41: WHERE intf.process_flag = 1
42: AND intf.set_process_id = xset_id
43: AND ((intf.organization_id = org_id) or (all_org = 1));
44:

Line 57: FROM Mtl_System_Items_Interface

53:
54: --Added for Bug 4366615
55: CURSOR C_puom_records IS
56: SELECT Primary_Unit_Of_Measure, ROWID
57: FROM Mtl_System_Items_Interface
58: WHERE Process_Flag = 1
59: AND Set_Process_Id = xset_id
60: AND ((organization_id = org_id) or (all_org = 1))
61: FOR UPDATE OF Primary_Uom_Code;

Line 112: UPDATE Mtl_System_Items_Interface

108: FROM Mtl_Units_Of_Measure
109: WHERE Unit_Of_Measure = puom.Primary_Unit_Of_Measure --Bug 5192495
110: AND SYSDATE < nvl(Disable_Date, SYSDATE+1);
111:
112: UPDATE Mtl_System_Items_Interface
113: SET Primary_Uom_Code = temp_uom_code
114: WHERE Rowid = puom.Rowid;
115: END IF;
116: EXCEPTION

Line 128: 'MTL_SYSTEM_ITEMS_INTERFACE',

124: request_id,
125: t_trans_id,
126: error_text,
127: 'PRIMARY_UNIT_OF_MEASURE',
128: 'MTL_SYSTEM_ITEMS_INTERFACE',
129: 'INV_IOI_PRIMARY_UOM',
130: err_text);
131: dumm_status := INVUPD2B.set_process_flag3(puom.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
132: END;

Line 295: 'MTL_SYSTEM_ITEMS_INTERFACE',

291: request_id,
292: t_trans_id,
293: error_text,
294: null,
295: 'MTL_SYSTEM_ITEMS_INTERFACE',
296: attr_err_mesg_name,
297: err_text);
298:
299: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

Line 333: 'MTL_SYSTEM_ITEMS_INTERFACE',

329: request_id,
330: t_trans_id,
331: error_text,
332: null,
333: 'MTL_SYSTEM_ITEMS_INTERFACE',
334: 'INV_STATUS_CNTRL_ATTRIB_ERROR',
335: err_text);
336: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
337: END IF; -- } */

Line 350: 'MTL_SYSTEM_ITEMS_INTERFACE',

346: request_id,
347: t_trans_id,
348: error_text,
349: null,
350: 'MTL_SYSTEM_ITEMS_INTERFACE',
351: 'INV_NON_UPDATE_ATTRIBUTE_ERROR',
352: err_text);
353: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
354: END IF; -- }

Line 367: 'MTL_SYSTEM_ITEMS_INTERFACE',

363: request_id,
364: t_trans_id,
365: error_text,
366: null,
367: 'MTL_SYSTEM_ITEMS_INTERFACE',
368: 'INV_NON_UPDATE_ATTR_ERROR2',
369: err_text);
370: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
371: END IF; -- }

Line 419: 'MTL_SYSTEM_ITEMS_INTERFACE',

415: request_id,
416: t_trans_id,
417: error_text,
418: null,
419: 'MTL_SYSTEM_ITEMS_INTERFACE',
420: 'INV_RECORD_NOT_FOUND_ERROR',
421: err_text);
422: RETURN (1);
423: WHEN OTHERS THEN

Line 464: from MTL_SYSTEM_ITEMS_INTERFACE

460: SECONDARY_DEFAULT_IND,
461: DUAL_UOM_DEVIATION_HIGH,
462: DUAL_UOM_DEVIATION_LOW
463: /* End Bug 3713912 */
464: from MTL_SYSTEM_ITEMS_INTERFACE
465: where rowid = row_id;
466:
467: cursor msi_attr is
468: select LOCATION_CONTROL_CODE,

Line 1032: from MTL_SYSTEM_ITEMS_INTERFACE

1028: MINIMUM_FILL_PERCENT,
1029: CONTAINER_TYPE_CODE,
1030: INTERNAL_VOLUME,
1031: SET_PROCESS_ID
1032: from MTL_SYSTEM_ITEMS_INTERFACE
1033: where process_flag = 1
1034: and set_process_id = xset_id
1035: and ((organization_id = org_id) or (all_org = 1));
1036:

Line 1115: 'MTL_SYSTEM_ITEMS_INTERFACE',

1111: request_id,
1112: t_trans_id,
1113: error_text,
1114: null,
1115: 'MTL_SYSTEM_ITEMS_INTERFACE',
1116: 'INV_ORGITEM_ID_NOT_FOUND',
1117: err_text);
1118: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1119: end if;

Line 1133: 'MTL_SYSTEM_ITEMS_INTERFACE',

1129: request_id,
1130: t_trans_id,
1131: error_text,
1132: null,
1133: 'MTL_SYSTEM_ITEMS_INTERFACE',
1134: 'INV_TEMPLATE_ERROR',
1135: err_text);
1136: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1137: status_code := 1;

Line 1150: 'MTL_SYSTEM_ITEMS_INTERFACE',

1146: request_id,
1147: t_trans_id,
1148: error_text,
1149: 'ITEM_NUMBER',
1150: 'MTL_SYSTEM_ITEMS_INTERFACE',
1151: 'INV_PARSE_ITEM_ERROR',
1152: err_text);
1153: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1154: END;

Line 1200: from MTL_SYSTEM_ITEMS_INTERFACE MSII

1196: return INTEGER
1197: IS
1198: CURSOR C_inv_item_id_records is
1199: select process_flag, organization_id, transaction_id
1200: from MTL_SYSTEM_ITEMS_INTERFACE MSII
1201: where MSII.inventory_item_id is not NULL
1202: and MSII.set_process_id = xset_id
1203: and MSII.process_flag = 1
1204: and not exists

Line 1235: 'MTL_SYSTEM_ITEMS_INTERFACE',

1231: request_id,
1232: rec.transaction_id,
1233: error_text,
1234: 'INVENTORY_ITEM_ID',
1235: 'MTL_SYSTEM_ITEMS_INTERFACE',
1236: 'INV_INV_ITEM_ID_NOEXIST_ERROR',
1237: err_text);
1238:
1239: update MTL_SYSTEM_ITEMS_INTERFACE

Line 1239: update MTL_SYSTEM_ITEMS_INTERFACE

1235: 'MTL_SYSTEM_ITEMS_INTERFACE',
1236: 'INV_INV_ITEM_ID_NOEXIST_ERROR',
1237: err_text);
1238:
1239: update MTL_SYSTEM_ITEMS_INTERFACE
1240: set process_flag = l_process_flag_3
1241: where current of C_inv_item_id_records;
1242: ret_code := 1;
1243:

Line 1305: mtl_system_items_interface msii

1301:
1302: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);
1303: DSQL_statement := 'select msi.inventory_item_id
1304: from mtl_system_items_B msi,
1305: mtl_system_items_interface msii
1306: where msii.rowid = :row_id_bind
1307: AND msi.organization_id = msii.organization_id
1308: and ' || statement_temp;
1309: DSQL_c := dbms_sql.open_cursor;

Line 1318: update MTL_SYSTEM_ITEMS_INTERFACE

1314: --
1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1316: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1317: --
1318: update MTL_SYSTEM_ITEMS_INTERFACE
1319: set inventory_item_id = DSQL_inventory_item_id
1320: where rowid = row_id;
1321: --
1322: inv_item_id := DSQL_inventory_item_id;

Line 1365: 'MTL_SYSTEM_ITEMS_INTERFACE',

1361: request_id,
1362: trans_id,
1363: error_text,
1364: null,
1365: 'MTL_SYSTEM_ITEMS_INTERFACE',
1366: 'INV_DYN_SQL_ERROR',
1367: err_text);
1368:
1369: dumm_status := INVUPD2B.set_process_flag3 (row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 1495: msii_temp_data MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;

1491: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Main'
1492: AND END_USER_COLUMN_NAME = 'Trade_Item_Descriptor';
1493:
1494: msi_record_temp MTL_SYSTEM_ITEMS_VL%ROWTYPE;
1495: msii_temp_data MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
1496: l_process_flag_2 NUMBER := 2;
1497: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1498:
1499: BEGIN -- {

Line 1511: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

1507: WHERE MSI.organization_id = org_id
1508: AND MSI.inventory_item_id = inv_item_id;
1509:
1510: SELECT * INTO msii_temp_data
1511: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
1512: WHERE MSII.ROWID = ROW_ID;
1513:
1514: -- Start 5565453 : Perf issue reducing the shared memory
1515: IF msii_temp_data.DAYS_MAX_INV_WINDOW IS NULL THEN

Line 4016: UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ROW = msii_temp_data WHERE ROWID = row_id;

4012: msii_temp_data.TRADE_ITEM_DESCRIPTOR := trim(msii_temp_data.TRADE_ITEM_DESCRIPTOR);
4013: END IF;
4014:
4015:
4016: UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ROW = msii_temp_data WHERE ROWID = row_id;
4017:
4018: -- End 5565453 : Perf issue reducing the shared memory
4019:
4020: RETURN (0);

Line 4262: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)

4258: IF status <> 0 THEN
4259: ----Bug: 3019435 Changed the code with in IF st.
4260: UPDATE mtl_item_revisions_interface
4261: SET process_flag = l_process_flag_3,
4262: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
4263: WHERE item_number = cr.item_number
4264: AND inventory_item_id IS NULL
4265: AND process_flag = l_process_flag_1
4266: AND set_process_id = xset_id

Line 4270: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

4266: AND set_process_id = xset_id
4267: AND organization_id = cr.organization_id
4268: RETURNING transaction_id INTO tran_id;
4269: /*
4270: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4271: INTO tran_id
4272: FROM dual;
4273: */
4274: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 4319: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

4315:
4316: --Assign Transaction Id
4317: FOR cr IN c_fill_transaction_id LOOP
4318:
4319: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4320: INTO tran_id FROM dual;
4321:
4322: UPDATE mtl_item_revisions_interface
4323: SET transaction_id = tran_id