eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_SEL_ATTR dependencies on ALL_TAB_COLUMNS

Line 274: /** Bug 2600351 -- selecting from all_Tab_columns causes performance issue.

270: p_table_name IN VARCHAR2
271: , p_column_name IN VARCHAR2
272: , x_column_type OUT NOCOPY VARCHAR2) IS
273:
274: /** Bug 2600351 -- selecting from all_Tab_columns causes performance issue.
275: It takes about 171 second from 173 thousand rows and the only rows we need is
276: only 10 rows **/
277:
278: /** Instead of selecting from all_tab_columns, we will just use PL/SQL processing to

Line 278: /** Instead of selecting from all_tab_columns, we will just use PL/SQL processing to

274: /** Bug 2600351 -- selecting from all_Tab_columns causes performance issue.
275: It takes about 171 second from 173 thousand rows and the only rows we need is
276: only 10 rows **/
277:
278: /** Instead of selecting from all_tab_columns, we will just use PL/SQL processing to
279: find out the column type, anyway, it is only 3 return types **/
280:
281: l_retVarchar VARCHAR2(15) := 'VARCHAR2';
282: l_retDate VARCHAR2(15) := 'DATE';

Line 1014: from all_tab_columns

1010: l_ret boolean;
1011:
1012: cursor column_csr(p_table_name VARCHAR2, p_owner VARCHAR2) is
1013: select column_name, data_type, data_length
1014: from all_tab_columns
1015: where table_name = p_table_name
1016: and owner = p_owner
1017: order by column_id;
1018: