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 1948: WHERE table_name = 'MTL_SYSTEM_ITEMS_INTERFACE'

1944:
1945: SELECT data_type
1946: INTO l_data_type
1947: FROM all_tab_columns
1948: WHERE table_name = 'MTL_SYSTEM_ITEMS_INTERFACE'
1949: AND owner = l_app_owner_schema
1950: AND column_name = upper(l_att_tab(l_current_att_index).item_column_name);
1951: ***/
1952:

Line 1957: WHERE syn.synonym_name = 'MTL_SYSTEM_ITEMS_INTERFACE'

1953: -- bug#15842720 fix for 12.2 OLP compatible
1954: SELECT data_type
1955: INTO l_data_type
1956: FROM user_synonyms syn, dba_tab_columns col
1957: WHERE syn.synonym_name = 'MTL_SYSTEM_ITEMS_INTERFACE'
1958: AND col.owner = syn.table_owner
1959: AND col.table_name = syn.table_name
1960: AND col.owner = l_app_owner_schema
1961: AND col.column_name = upper(l_att_tab(l_current_att_index).item_column_name);

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

1982:
1983: END IF;
1984:
1985: /*myerrams, Modified the following query to use bind variables. Bug: 5001785*/
1986: l_dml_str := 'UPDATE mtl_system_items_interface int SET (int.'
1987: || l_att_tab(l_current_att_index).item_column_name
1988: || ') = ('
1989: || ' SELECT tmp.chosen_value'
1990: || ' FROM mtl_item_values_temp tmp '