APPS.INV_ITEM_ATTRIBUTES_PKG dependencies on MTL_ITEM_VALUES_TEMP

Line 1712: FROM mtl_item_values_temp

1708:
1709: CURSOR att_cur IS
1710: SELECT item_column_name
1711: ,chosen_value
1712: FROM mtl_item_values_temp
1713: WHERE item_update_id = p_seq_id
1714: ORDER BY current_att_index;
1715:
1716: CURSOR sel_cur IS

Line 1925: FROM mtl_item_values_temp

1921: -- the values to copy from
1922:
1923: SELECT count(*)
1924: INTO l_count
1925: FROM mtl_item_values_temp
1926: WHERE item_update_id = p_seq_id;
1927:
1928: LOOP
1929:

Line 1951: UPDATE mtl_item_values_temp tmp

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
1951: UPDATE mtl_item_values_temp tmp
1952: SET tmp.chosen_value = '-999999'
1953: WHERE tmp.current_att_index = l_current_att_index
1954: AND tmp.item_update_id = p_seq_id;
1955: ELSIF l_data_type = 'VARCHAR2' THEN

Line 1956: UPDATE mtl_item_values_temp tmp

1952: SET tmp.chosen_value = '-999999'
1953: WHERE tmp.current_att_index = l_current_att_index
1954: AND tmp.item_update_id = p_seq_id;
1955: ELSIF l_data_type = 'VARCHAR2' THEN
1956: UPDATE mtl_item_values_temp tmp
1957: SET tmp.chosen_value = '!'
1958: WHERE tmp.current_att_index = l_current_att_index
1959: AND tmp.item_update_id = p_seq_id;
1960: END IF;

Line 1964: UPDATE mtl_item_values_temp tmp

1960: END IF;
1961:
1962: ELSE
1963:
1964: UPDATE mtl_item_values_temp tmp
1965: SET tmp.chosen_value = FND_PROFILE.VALUE('INV_STATUS_DEFAULT')
1966: WHERE tmp.current_att_index = l_current_att_index
1967: AND tmp.item_update_id = p_seq_id;
1968: END IF; -- inventory_item_status_code check

Line 1977: || ' FROM mtl_item_values_temp tmp '

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 '
1978: || ' WHERE tmp.current_att_index = :1'
1979: || ' AND tmp.item_update_id = :2'
1980: || ') WHERE (int.set_process_id = :3'
1981: || ')';

Line 2031: DELETE mtl_item_values_temp

2027: END IF;
2028:
2029: Wait_For_All_Workers(p_workers => l_workers_tbl);
2030:
2031: DELETE mtl_item_values_temp
2032: WHERE item_update_id = p_seq_id;
2033:
2034: DELETE mtl_update_records_temp
2035: WHERE item_update_id = p_seq_id;

Line 2106: INSERT INTO mtl_item_values_temp(item_update_id

2102: -- have been assigned dynamically. for more please read the dld
2103:
2104: LOOP
2105:
2106: INSERT INTO mtl_item_values_temp(item_update_id
2107: ,item_column_name
2108: ,chosen_value
2109: ,current_att_index
2110: )