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.HZ_PURGE dependencies on DBA_IND_COLUMNS

Line 1326: select min(column_position) from dba_ind_columns where table_name = ent_name

1322: indexname VARCHAR2(100);
1323: upper_join_clause VARCHAR2(2000);
1324:
1325: cursor column_position(ent_name varchar2, ent_col_name varchar2, schema1 varchar2) is
1326: select min(column_position) from dba_ind_columns where table_name = ent_name
1327: and column_name = ent_col_name
1328: and index_owner = schema1 and table_owner = schema1;
1329:
1330: cursor col_indexes(ent_name varchar2, colmn_name varchar2, schema1 varchar2) is

Line 1331: select index_name, column_position from dba_ind_columns

1327: and column_name = ent_col_name
1328: and index_owner = schema1 and table_owner = schema1;
1329:
1330: cursor col_indexes(ent_name varchar2, colmn_name varchar2, schema1 varchar2) is
1331: select index_name, column_position from dba_ind_columns
1332: where table_name = ent_name and column_name = colmn_name
1333: and index_owner = schema1 and table_owner = schema1;
1334:
1335: cursor preceeding_columns(ent_name varchar2, ind_name varchar2, col_position NUMBER, schema1 varchar2) is

Line 1336: select column_name from dba_ind_columns where table_name = ent_name

1332: where table_name = ent_name and column_name = colmn_name
1333: and index_owner = schema1 and table_owner = schema1;
1334:
1335: cursor preceeding_columns(ent_name varchar2, ind_name varchar2, col_position NUMBER, schema1 varchar2) is
1336: select column_name from dba_ind_columns where table_name = ent_name
1337: and index_name = ind_name
1338: and column_position 1339: and index_owner = schema1 and table_owner = schema1;
1340: