APPS.ETRM_FNDNAV dependencies on FND_INDEXES

Line 718: cursor cur_index(n_appid in fnd_indexes.application_id%type

714: and table_id = n_tabid
715: order by table_name;
716: --
717:
718: cursor cur_index(n_appid in fnd_indexes.application_id%type
719: , n_tabid in fnd_indexes.table_id%type)
720: -- List Indexes
721: is select ind.index_name
722: , ind.index_id

Line 719: , n_tabid in fnd_indexes.table_id%type)

715: order by table_name;
716: --
717:
718: cursor cur_index(n_appid in fnd_indexes.application_id%type
719: , n_tabid in fnd_indexes.table_id%type)
720: -- List Indexes
721: is select ind.index_name
722: , ind.index_id
723: , decode(ind.uniqueness, 'N', 'Non Unique'

Line 726: from fnd_indexes ind

722: , ind.index_id
723: , decode(ind.uniqueness, 'N', 'Non Unique'
724: , 'Y', 'Unique') uniqueness
725: , ind.description
726: from fnd_indexes ind
727: where ind.application_id = n_appid
728: and ind.table_id = n_tabid
729: order by ind.uniqueness desc, ind.index_name;
730: --

Line 731: cursor cur_index_col(n_appid in fnd_indexes.application_id%type

727: where ind.application_id = n_appid
728: and ind.table_id = n_tabid
729: order by ind.uniqueness desc, ind.index_name;
730: --
731: cursor cur_index_col(n_appid in fnd_indexes.application_id%type
732: , n_tabid in fnd_indexes.table_id%type
733: , n_index in fnd_indexes.index_id%type)
734: -- List index columns
735: is select c.column_name

Line 732: , n_tabid in fnd_indexes.table_id%type

728: and ind.table_id = n_tabid
729: order by ind.uniqueness desc, ind.index_name;
730: --
731: cursor cur_index_col(n_appid in fnd_indexes.application_id%type
732: , n_tabid in fnd_indexes.table_id%type
733: , n_index in fnd_indexes.index_id%type)
734: -- List index columns
735: is select c.column_name
736: from fnd_index_columns i

Line 733: , n_index in fnd_indexes.index_id%type)

729: order by ind.uniqueness desc, ind.index_name;
730: --
731: cursor cur_index_col(n_appid in fnd_indexes.application_id%type
732: , n_tabid in fnd_indexes.table_id%type
733: , n_index in fnd_indexes.index_id%type)
734: -- List index columns
735: is select c.column_name
736: from fnd_index_columns i
737: , fnd_columns c