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 233: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'

229: -- Start 2913856 Changed is not null to <>
230: --4751471 : Status attributes under sets control
231: --Values passed in the interface table should be compared against status setup not against msb db value.
232: FOR srec IN C_status_controlled_attr(nvl(rec.inventory_item_status_code,msi_inventory_item_status_code)) LOOP -- {
233: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'
234: AND NVL(rec.STOCK_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
236: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
237: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'

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

231: --Values passed in the interface table should be compared against status setup not against msb db value.
232: FOR srec IN C_status_controlled_attr(nvl(rec.inventory_item_status_code,msi_inventory_item_status_code)) LOOP -- {
233: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'
234: AND NVL(rec.STOCK_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
236: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
237: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
238: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'

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

233: IF((srec.attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG'
234: AND NVL(rec.STOCK_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
236: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
237: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
238: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
240: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'

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

235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
236: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
237: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
238: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
240: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
242: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'

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

237: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
238: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
240: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
242: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
244: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
245: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

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

239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
240: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
242: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
244: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
245: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
246: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
247: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'

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

241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
242: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
244: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
245: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
246: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
247: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
248: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
249: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'

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

243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
244: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
245: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
246: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
247: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
248: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
249: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'
250: AND NVL(rec.RECIPE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
251: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'

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

245: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
246: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
247: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
248: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
249: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'
250: AND NVL(rec.RECIPE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
251: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'
252: AND NVL(rec.PROCESS_EXECUTION_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value))
253: THEN -- {

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

247: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
248: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
249: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'
250: AND NVL(rec.RECIPE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
251: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'
252: AND NVL(rec.PROCESS_EXECUTION_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value))
253: THEN -- {
254: status_code := 0;
255: END IF; -- }

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

497: SECONDARY_DEFAULT_IND,
498: DUAL_UOM_DEVIATION_HIGH,
499: DUAL_UOM_DEVIATION_LOW
500: /* End Bug 3713912 */
501: from MTL_SYSTEM_ITEMS
502: where inventory_item_id = item_id
503: and organization_id = org_id;
504:
505: msii_rec msii_attr%rowtype;

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

1218: and MSII.set_process_id = xset_id
1219: and MSII.process_flag = 1
1220: and not exists
1221: (select inventory_item_id
1222: from MTL_SYSTEM_ITEMS_B MSI
1223: where MSII.inventory_item_id = MSI.inventory_item_id
1224: and MSII.organization_id = MSI.organization_id)
1225: for update;
1226:

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

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

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

1346: end if; -- }
1347:
1348: select organization_id
1349: into tmp_orgid
1350: from MTL_SYSTEM_ITEMS_B
1351: where organization_id = org_id
1352: and inventory_item_id = inv_item_id;
1353:
1354: return (1);

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

1442: CURSOR C_child_msi_records IS
1443: select
1444: MSI.INVENTORY_ITEM_ID,
1445: MSI.ORGANIZATION_ID
1446: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1447: where MP.master_organization_id = org_id
1448: and MP.organization_id = MSI.organization_id
1449: and MSI.inventory_item_id = inv_item_id
1450: and MSI.organization_id <> MP.master_organization_id;

Line 1510: msi_record_temp MTL_SYSTEM_ITEMS_VL%ROWTYPE;

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

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

1518: INVPUTLI.info('INVUPD1B: Inside copy_msi_to_msii'|| '***orgid: ' || TO_CHAR(org_id));
1519: END IF;
1520:
1521: SELECT * INTO msi_record_temp
1522: FROM MTL_SYSTEM_ITEMS_VL MSI
1523: WHERE MSI.organization_id = org_id
1524: AND MSI.inventory_item_id = inv_item_id;
1525:
1526: SELECT * INTO msii_temp_data

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