APPS.INV_ITEM_ATTRIBUTES_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 1326: FROM mtl_system_items_interface

1322: END IF;
1323:
1324: SELECT COUNT(*)
1325: INTO l_error_count
1326: FROM mtl_system_items_interface
1327: WHERE NVL(request_id, 0) = NVL(FND_GLOBAL.conc_request_id, 0);
1328:
1329: IF l_error_count > 0 THEN
1330: x_retcode := RETCODE_WARNING;

Line 1881: INSERT INTO mtl_system_items_interface

1877: -- loop through all the records to be updated
1878:
1879: l_current_att_index := 0;
1880:
1881: INSERT INTO mtl_system_items_interface
1882: ( process_flag
1883: , set_process_id
1884: , transaction_type
1885: , inventory_item_id

Line 1946: WHERE table_name = 'MTL_SYSTEM_ITEMS_INTERFACE'

1942:
1943: SELECT data_type
1944: INTO l_data_type
1945: FROM all_tab_columns
1946: WHERE table_name = 'MTL_SYSTEM_ITEMS_INTERFACE'
1947: AND owner = l_app_owner_schema
1948: AND column_name = upper(l_att_tab(l_current_att_index).item_column_name);
1949:
1950: IF l_data_type = 'NUMBER' THEN

Line 1973: l_dml_str := 'UPDATE mtl_system_items_interface int SET (int.'

1969:
1970: END IF;
1971:
1972: /*myerrams, Modified the following query to use bind variables. Bug: 5001785*/
1973: l_dml_str := 'UPDATE mtl_system_items_interface int SET (int.'
1974: || l_att_tab(l_current_att_index).item_column_name
1975: || ') = ('
1976: || ' SELECT tmp.chosen_value'
1977: || ' FROM mtl_item_values_temp tmp '