132: ,xem.column_title PROMPT
133: ,utc.data_type data_type
134: FROM xla_entity_id_mappings xid
135: ,xla_event_mappings_vl xem
136: ,user_tab_columns utc
137: WHERE xid.application_id = p_application_id
138: AND xid.entity_code = p_entity_code
139: AND xem.application_id = p_application_id
140: AND xem.entity_code = p_entity_code
288: ----------------------------------------------------------------------
289: -- build and execute a dummy query if the view name is defined for
290: -- the class
291: -- NOTE: following never fails because the cursor joins to
292: -- user_tab_columns table that will make sure that view and column
293: -- names fetched exists. This can beremoved unless we decide to go
294: -- for outerjoin on this table.
295: ----------------------------------------------------------------------
296: l_sql_string :=
935: ,xem.column_title PROMPT
936: ,utc.data_type data_type
937: FROM xla_entity_id_mappings xid
938: ,xla_event_mappings_vl xem
939: ,user_tab_columns utc
940: WHERE xid.application_id = cur_trx.application_id
941: AND xid.entity_code = cur_trx.entity_code
942: AND xem.application_id = cur_trx.application_id
943: AND xem.entity_code = cur_trx.entity_code