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

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 86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;

82: temp_uom_code VARCHAR2(3);
83: msi_primary_uom_code VARCHAR2(3);
84: --End of Bug 4366615
85:
86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;
87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;

Line 87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;

83: msi_primary_uom_code VARCHAR2(3);
84: --End of Bug 4366615
85:
86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;
87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;

Line 88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;

84: --End of Bug 4366615
85:
86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;
87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:

Line 89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;

85:
86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;
87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:
93: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

Line 90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;

86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;
87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:
93: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
94:

Line 91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;

87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:
93: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
94:
95:

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 166: FROM mtl_system_items_B msi

162: msi_secondary_default_ind,
163: msi_ont_pricing_qty_source,
164: msi_dual_uom_deviation_high,
165: msi_dual_uom_deviation_low
166: FROM mtl_system_items_B msi
167: WHERE msi.inventory_item_id = t_inventory_item_id
168: AND msi.organization_id = t_organization_id;
169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN

Line 217: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'

213: -- Start 2913856 Changed is not null to <>
214: --4751471 : Status attributes under sets control
215: --Values passed in the interface table should be compared against status setup not against msb db value.
216: FOR srec IN C_status_controlled_attr(nvl(rec.inventory_item_status_code,msi_inventory_item_status_code)) LOOP -- {
217: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'
218: AND NVL(rec.STOCK_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
219: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
220: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'

Line 219: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'

215: --Values passed in the interface table should be compared against status setup not against msb db value.
216: FOR srec IN C_status_controlled_attr(nvl(rec.inventory_item_status_code,msi_inventory_item_status_code)) LOOP -- {
217: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'
218: AND NVL(rec.STOCK_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
219: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
220: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
222: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'

Line 221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'

217: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'
218: AND NVL(rec.STOCK_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
219: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
220: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
222: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
224: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'

Line 223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'

219: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
220: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
222: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
224: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
226: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'

Line 225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'

221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
222: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
224: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
226: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
228: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

Line 227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'

223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
224: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
226: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
228: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
230: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'

Line 229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
226: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
228: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
230: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
232: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
233: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'

Line 231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'

227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
228: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
230: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
232: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
233: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'
234: AND NVL(rec.RECIPE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'

Line 233: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'

229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
230: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
232: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
233: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'
234: AND NVL(rec.RECIPE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'
236: AND NVL(rec.PROCESS_EXECUTION_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value))
237: THEN -- {

Line 235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'

231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
232: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
233: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'
234: AND NVL(rec.RECIPE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'
236: AND NVL(rec.PROCESS_EXECUTION_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value))
237: THEN -- {
238: status_code := 0;
239: END IF; -- }

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 485: from MTL_SYSTEM_ITEMS

481: SECONDARY_DEFAULT_IND,
482: DUAL_UOM_DEVIATION_HIGH,
483: DUAL_UOM_DEVIATION_LOW
484: /* End Bug 3713912 */
485: from MTL_SYSTEM_ITEMS
486: where inventory_item_id = item_id
487: and organization_id = org_id;
488:
489: msii_rec msii_attr%rowtype;

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 1206: from MTL_SYSTEM_ITEMS_B MSI

1202: and MSII.set_process_id = xset_id
1203: and MSII.process_flag = 1
1204: and not exists
1205: (select inventory_item_id
1206: from MTL_SYSTEM_ITEMS_B MSI
1207: where MSII.inventory_item_id = MSI.inventory_item_id
1208: and MSII.organization_id = MSI.organization_id)
1209: for update;
1210:

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 1304: from mtl_system_items_B msi,

1300: if inv_item_id is null then -- {
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;

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 1334: from MTL_SYSTEM_ITEMS_B

1330: end if; -- }
1331:
1332: select organization_id
1333: into tmp_orgid
1334: from MTL_SYSTEM_ITEMS_B
1335: where organization_id = org_id
1336: and inventory_item_id = inv_item_id;
1337:
1338: return (1);

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 1430: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1426: CURSOR C_child_msi_records IS
1427: select
1428: MSI.INVENTORY_ITEM_ID,
1429: MSI.ORGANIZATION_ID
1430: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1431: where MP.master_organization_id = org_id
1432: and MP.organization_id = MSI.organization_id
1433: and MSI.inventory_item_id = inv_item_id
1434: and MSI.organization_id <> MP.master_organization_id;

Line 1494: msi_record_temp MTL_SYSTEM_ITEMS_VL%ROWTYPE;

1490: AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_MASTER_ITEMS'
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:

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 1506: FROM MTL_SYSTEM_ITEMS_VL MSI

1502: INVPUTLI.info('INVUPD1B: Inside copy_msi_to_msii'|| '***orgid: ' || TO_CHAR(org_id));
1503: END IF;
1504:
1505: SELECT * INTO msi_record_temp
1506: FROM MTL_SYSTEM_ITEMS_VL MSI
1507: WHERE MSI.organization_id = org_id
1508: AND MSI.inventory_item_id = inv_item_id;
1509:
1510: SELECT * INTO msii_temp_data

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