159: ,xem.column_title prompt
160: ,utc.data_type data_type
161: FROM xla_entity_id_mappings xid
162: ,xla_event_mappings_vl xem
163: ,user_tab_columns utc
164: WHERE xid.application_id = p_application_id
165: AND xid.entity_code = p_entity_code
166: AND xem.application_id = p_application_id
167: AND xem.entity_code = p_entity_code
324: ----------------------------------------------------------------------
325: -- build and execute a dummy query if the view name is defined for
326: -- the class
327: -- NOTE: following never fails because the cursor joins to
328: -- user_tab_columns table that will make sure that view and column
329: -- names fetched exists. This can beremoved unless we decide to go
330: -- for outerjoin on this table.
331: ----------------------------------------------------------------------
332: l_sql_string :=
452: ,xem.column_title prompt
453: ,utc.data_type data_type
454: FROM xla_entity_id_mappings xid
455: ,xla_event_mappings_vl xem
456: ,user_tab_columns utc
457: WHERE xid.application_id = p_application_id
458: AND xid.entity_code = p_entity_code
459: AND xem.application_id = p_application_id
460: AND xem.entity_code = p_entity_code