[Home] [Help]
34: --| 09-FEB-04 vjavli GSCC fix: file.sql.47 |
35: --| FND_INSTALLATION.get_app_info used to obtain |
36: --| owner of database schema. This will be used in |
37: --| WHERE condition to compare with owner along with |
38: --| table_name of all_tab_columns |
39: --| 10-FEB-04 nkilleda Bug#3148944 fix: Unapproved items should be |
40: --| excluded from item range when item from and item |
41: --| to fields are input by user. These items are PLM |
42: --| items and should not be visible to an ERPuser. |
1941: THEN
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: