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.XLA_REPORT_UTILITY_PKG dependencies on USER_TAB_COLUMNS

Line 786: -- ,user_tab_columns utc

782: -- ,xem.column_title PROMPT
783: -- ,utc.data_type data_type
784: FROM xla_entity_id_mappings xid
785: -- ,xla_event_mappings_vl xem
786: -- ,user_tab_columns utc
787: WHERE xid.application_id = p_application_id
788: AND xid.entity_code = p_entity_code
789: /* AND xem.application_id = p_application_id
790: AND xem.entity_code = p_entity_code

Line 907: FROM user_tab_columns t , user_objects o

903: (SELECT xem.column_name column_name
904: ,xem.column_title PROMPT
905: ,utc.data_type data_type
906: FROM (SELECT t.table_name , t.column_name ,t.data_type
907: FROM user_tab_columns t , user_objects o
908: WHERE t.table_name = o.object_name
909: AND o.object_name = p_reporting_view_name
910: AND o.object_type <> 'SYNONYM'
911: UNION ALL

Line 977: -- user_tab_columns table that will make sure that view and column

973: ----------------------------------------------------------------------
974: -- build and execute a dummy query if the view name is defined for
975: -- the class
976: -- NOTE: following never fails because the cursor joins to
977: -- user_tab_columns table that will make sure that view and column
978: -- names fetched exists. This can beremoved unless we decide to go
979: -- for outerjoin on this table.
980: ----------------------------------------------------------------------
981: l_sql_string :=

Line 1641: -- ,user_tab_columns utc

1637: -- ,xem.column_title PROMPT
1638: -- ,utc.data_type data_type
1639: FROM xla_entity_id_mappings xid
1640: -- ,xla_event_mappings_vl xem
1641: -- ,user_tab_columns utc
1642: WHERE xid.application_id = cur_trx.application_id
1643: AND xid.entity_code = cur_trx.entity_code)
1644: -- AND xem.application_id = cur_trx.application_id
1645: -- AND xem.entity_code = cur_trx.entity_code

Line 1701: FROM user_tab_columns t , user_objects o

1697: (SELECT xem.column_name column_name
1698: ,xem.column_title PROMPT
1699: ,utc.data_type data_type
1700: FROM (SELECT t.table_name , t.column_name ,t.data_type
1701: FROM user_tab_columns t , user_objects o
1702: WHERE t.table_name = o.object_name
1703: AND o.object_name = cur_trx.reporting_view_name
1704: AND o.object_type <> 'SYNONYM'
1705: UNION ALL

Line 1899: -- ,user_tab_columns utc

1895: -- ,xem.column_title PROMPT
1896: -- ,utc.data_type data_type
1897: FROM xla_entity_id_mappings xid
1898: -- ,xla_event_mappings_vl xem
1899: -- ,user_tab_columns utc
1900: WHERE xid.application_id = cur_trx.application_id
1901: AND xid.entity_code = cur_trx.entity_code)
1902: -- AND xem.application_id = cur_trx.application_id
1903: -- AND xem.entity_code = cur_trx.entity_code

Line 1959: FROM user_tab_columns t , user_objects o

1955: (SELECT xem.column_name column_name
1956: ,xem.column_title PROMPT
1957: ,utc.data_type data_type
1958: FROM (SELECT t.table_name , t.column_name ,t.data_type
1959: FROM user_tab_columns t , user_objects o
1960: WHERE t.table_name = o.object_name
1961: AND o.object_name = cur_trx.reporting_view_name
1962: AND o.object_type <> 'SYNONYM'
1963: UNION ALL