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 1964: UPDATE mtl_item_values_temp tmp

1960: AND col.owner = l_app_owner_schema
1961: AND col.column_name = upper(l_att_tab(l_current_att_index).item_column_name);
1962:
1963: IF l_data_type = 'NUMBER' THEN
1964: UPDATE mtl_item_values_temp tmp
1965: SET tmp.chosen_value = '-999999'
1966: WHERE tmp.current_att_index = l_current_att_index
1967: AND tmp.item_update_id = p_seq_id;
1968: ELSIF l_data_type = 'VARCHAR2' THEN

Line 1969: UPDATE mtl_item_values_temp tmp

1965: SET tmp.chosen_value = '-999999'
1966: WHERE tmp.current_att_index = l_current_att_index
1967: AND tmp.item_update_id = p_seq_id;
1968: ELSIF l_data_type = 'VARCHAR2' THEN
1969: UPDATE mtl_item_values_temp tmp
1970: SET tmp.chosen_value = '!'
1971: WHERE tmp.current_att_index = l_current_att_index
1972: AND tmp.item_update_id = p_seq_id;
1973: END IF;

Line 1977: UPDATE mtl_item_values_temp tmp

1973: END IF;
1974:
1975: ELSE
1976:
1977: UPDATE mtl_item_values_temp tmp
1978: SET tmp.chosen_value = FND_PROFILE.VALUE('INV_STATUS_DEFAULT')
1979: WHERE tmp.current_att_index = l_current_att_index
1980: AND tmp.item_update_id = p_seq_id;
1981: END IF; -- inventory_item_status_code check

Line 1990: || ' FROM mtl_item_values_temp tmp '

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 '
1991: || ' WHERE tmp.current_att_index = :1'
1992: || ' AND tmp.item_update_id = :2'
1993: || ') WHERE (int.set_process_id = :3'
1994: || ')';

Line 2044: DELETE mtl_item_values_temp

2040: END IF;
2041:
2042: Wait_For_All_Workers(p_workers => l_workers_tbl);
2043:
2044: DELETE mtl_item_values_temp
2045: WHERE item_update_id = p_seq_id;
2046:
2047: DELETE mtl_update_records_temp
2048: WHERE item_update_id = p_seq_id;

Line 2119: INSERT INTO mtl_item_values_temp(item_update_id

2115: -- have been assigned dynamically. for more please read the dld
2116:
2117: LOOP
2118:
2119: INSERT INTO mtl_item_values_temp(item_update_id
2120: ,item_column_name
2121: ,chosen_value
2122: ,current_att_index
2123: )