DBA Data[Home] [Help]

APPS.ETRM_FNDNAV dependencies on FND_COLUMNS

Line 737: , fnd_columns c

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
738: where i.application_id = n_appid
739: and i.table_id = n_tabid
740: and i.index_id = n_index
741: and c.application_id = i.application_id

Line 762: from applsys.fnd_columns c

758: cursor cur_pk_columns(n_tabid in number
759: , n_appid in number
760: , n_keyid in number) is
761: SELECT c.column_name
762: from applsys.fnd_columns c
763: , applsys.fnd_primary_key_columns k
764: where k.table_id = c.table_id
765: and k.application_id = c.application_id
766: and k.column_id = c.column_id

Line 804: from applsys.fnd_columns c

800: cursor cur_fk_columns(n_tabid in number
801: , n_appid in number
802: , n_keyid in number) is
803: SELECT c.column_name
804: from applsys.fnd_columns c
805: , applsys.fnd_foreign_key_columns k
806: where k.table_id = c.table_id
807: and k.application_id = c.application_id
808: and k.column_id = c.column_id

Line 838: from applsys.fnd_columns col

834: , nvl(to_char(col.precision), '
') data_precision
835: , nvl(decode(col.null_allowed_flag, 'N', 'NOT_NULL'
836: , 'Y', '
'), '
') nullable
837: , nvl(description, '
') description
838: from applsys.fnd_columns col
839: where col.table_id = n_tabid
840: and col.application_id = n_appid
841: order by col.column_sequence;
842: