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 311: 'MTL_SYSTEM_ITEMS_INTERFACE',

307: request_id,
308: t_trans_id,
309: error_text,
310: null,
311: 'MTL_SYSTEM_ITEMS_INTERFACE',
312: attr_err_mesg_name,
313: err_text);
314:
315: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);

Line 349: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 366: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 383: 'MTL_SYSTEM_ITEMS_INTERFACE',

379: request_id,
380: t_trans_id,
381: error_text,
382: null,
383: 'MTL_SYSTEM_ITEMS_INTERFACE',
384: 'INV_NON_UPDATE_ATTR_ERROR2',
385: err_text);
386: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
387: END IF; -- }

Line 435: 'MTL_SYSTEM_ITEMS_INTERFACE',

431: request_id,
432: t_trans_id,
433: error_text,
434: null,
435: 'MTL_SYSTEM_ITEMS_INTERFACE',
436: 'INV_RECORD_NOT_FOUND_ERROR',
437: err_text);
438: RETURN (1);
439: WHEN OTHERS THEN

Line 480: from MTL_SYSTEM_ITEMS_INTERFACE

476: SECONDARY_DEFAULT_IND,
477: DUAL_UOM_DEVIATION_HIGH,
478: DUAL_UOM_DEVIATION_LOW
479: /* End Bug 3713912 */
480: from MTL_SYSTEM_ITEMS_INTERFACE
481: where rowid = row_id;
482:
483: cursor msi_attr is
484: select LOCATION_CONTROL_CODE,

Line 1048: from MTL_SYSTEM_ITEMS_INTERFACE

1044: MINIMUM_FILL_PERCENT,
1045: CONTAINER_TYPE_CODE,
1046: INTERNAL_VOLUME,
1047: SET_PROCESS_ID
1048: from MTL_SYSTEM_ITEMS_INTERFACE
1049: where process_flag = 1
1050: and set_process_id = xset_id
1051: and ((organization_id = org_id) or (all_org = 1));
1052:

Line 1131: 'MTL_SYSTEM_ITEMS_INTERFACE',

1127: request_id,
1128: t_trans_id,
1129: error_text,
1130: null,
1131: 'MTL_SYSTEM_ITEMS_INTERFACE',
1132: 'INV_ORGITEM_ID_NOT_FOUND',
1133: err_text);
1134: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1135: end if;

Line 1149: 'MTL_SYSTEM_ITEMS_INTERFACE',

1145: request_id,
1146: t_trans_id,
1147: error_text,
1148: null,
1149: 'MTL_SYSTEM_ITEMS_INTERFACE',
1150: 'INV_TEMPLATE_ERROR',
1151: err_text);
1152: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1153: status_code := 1;

Line 1166: 'MTL_SYSTEM_ITEMS_INTERFACE',

1162: request_id,
1163: t_trans_id,
1164: error_text,
1165: 'ITEM_NUMBER',
1166: 'MTL_SYSTEM_ITEMS_INTERFACE',
1167: 'INV_PARSE_ITEM_ERROR',
1168: err_text);
1169: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1170: END;

Line 1216: from MTL_SYSTEM_ITEMS_INTERFACE MSII

1212: return INTEGER
1213: IS
1214: CURSOR C_inv_item_id_records is
1215: select process_flag, organization_id, transaction_id
1216: from MTL_SYSTEM_ITEMS_INTERFACE MSII
1217: where MSII.inventory_item_id is not NULL
1218: and MSII.set_process_id = xset_id
1219: and MSII.process_flag = 1
1220: and not exists

Line 1251: 'MTL_SYSTEM_ITEMS_INTERFACE',

1247: request_id,
1248: rec.transaction_id,
1249: error_text,
1250: 'INVENTORY_ITEM_ID',
1251: 'MTL_SYSTEM_ITEMS_INTERFACE',
1252: 'INV_INV_ITEM_ID_NOEXIST_ERROR',
1253: err_text);
1254:
1255: update MTL_SYSTEM_ITEMS_INTERFACE

Line 1255: update MTL_SYSTEM_ITEMS_INTERFACE

1251: 'MTL_SYSTEM_ITEMS_INTERFACE',
1252: 'INV_INV_ITEM_ID_NOEXIST_ERROR',
1253: err_text);
1254:
1255: update MTL_SYSTEM_ITEMS_INTERFACE
1256: set process_flag = l_process_flag_3
1257: where current of C_inv_item_id_records;
1258: ret_code := 1;
1259:

Line 1321: mtl_system_items_interface msii

1317:
1318: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);
1319: DSQL_statement := 'select msi.inventory_item_id
1320: from mtl_system_items_B msi,
1321: mtl_system_items_interface msii
1322: where msii.rowid = :row_id_bind
1323: AND msi.organization_id = msii.organization_id
1324: and ' || statement_temp;
1325: DSQL_c := dbms_sql.open_cursor;

Line 1334: update MTL_SYSTEM_ITEMS_INTERFACE

1330: --
1331: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1332: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1333: --
1334: update MTL_SYSTEM_ITEMS_INTERFACE
1335: set inventory_item_id = DSQL_inventory_item_id
1336: where rowid = row_id;
1337: --
1338: inv_item_id := DSQL_inventory_item_id;

Line 1381: 'MTL_SYSTEM_ITEMS_INTERFACE',

1377: request_id,
1378: trans_id,
1379: error_text,
1380: null,
1381: 'MTL_SYSTEM_ITEMS_INTERFACE',
1382: 'INV_DYN_SQL_ERROR',
1383: err_text);
1384:
1385: dumm_status := INVUPD2B.set_process_flag3 (row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 1511: msii_temp_data MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;

1507: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Main'
1508: AND END_USER_COLUMN_NAME = 'Trade_Item_Descriptor';
1509:
1510: msi_record_temp MTL_SYSTEM_ITEMS_VL%ROWTYPE;
1511: msii_temp_data MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
1512: l_process_flag_2 NUMBER := 2;
1513: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1514:
1515: BEGIN -- {

Line 1527: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

1523: WHERE MSI.organization_id = org_id
1524: AND MSI.inventory_item_id = inv_item_id;
1525:
1526: SELECT * INTO msii_temp_data
1527: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
1528: WHERE MSII.ROWID = ROW_ID;
1529:
1530: -- Start 5565453 : Perf issue reducing the shared memory
1531: IF msii_temp_data.DAYS_MAX_INV_WINDOW IS NULL THEN

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

4039: msii_temp_data.TRADE_ITEM_DESCRIPTOR := trim(msii_temp_data.TRADE_ITEM_DESCRIPTOR);
4040: END IF;
4041:
4042:
4043: UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ROW = msii_temp_data WHERE ROWID = row_id;
4044:
4045: -- End 5565453 : Perf issue reducing the shared memory
4046:
4047: RETURN (0);

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

4285: IF status <> 0 THEN
4286: ----Bug: 3019435 Changed the code with in IF st.
4287: UPDATE mtl_item_revisions_interface
4288: SET process_flag = l_process_flag_3,
4289: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
4290: WHERE item_number = cr.item_number
4291: AND inventory_item_id IS NULL
4292: AND process_flag = l_process_flag_1
4293: AND set_process_id = xset_id

Line 4297: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

4293: AND set_process_id = xset_id
4294: AND organization_id = cr.organization_id
4295: RETURNING transaction_id INTO tran_id;
4296: /*
4297: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4298: INTO tran_id
4299: FROM dual;
4300: */
4301: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 4346: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

4342:
4343: --Assign Transaction Id
4344: FOR cr IN c_fill_transaction_id LOOP
4345:
4346: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4347: INTO tran_id FROM dual;
4348:
4349: UPDATE mtl_item_revisions_interface
4350: SET transaction_id = tran_id