DBA Data[Home] [Help]

APPS.XLA_MULTIPERIOD_RPRTG_PKG dependencies on USER_OBJECTS

Line 338: FROM user_tab_columns t , user_objects o

334: (SELECT xem.column_name column_name
335: ,xem.column_title PROMPT
336: ,utc.data_type data_type
337: FROM (SELECT t.table_name , t.column_name ,t.data_type
338: FROM user_tab_columns t , user_objects o
339: WHERE t.table_name = o.object_name
340: AND o.object_name = cur_trx.reporting_view_name
341: AND o.object_type <> 'SYNONYM'
342: UNION ALL

Line 347: FROM user_synonyms s , user_objects o

343: SELECT dt.table_name, dt.column_name , dt.data_type
344: FROM dba_tab_columns dt
345: WHERE (dt.table_name , dt.owner)
346: IN ( SELECT s.table_name , s.table_owner
347: FROM user_synonyms s , user_objects o
348: WHERE 1 = 1
349: AND o.object_name = cur_trx.reporting_view_name
350: AND o.object_type = 'SYNONYM'
351: AND s.synonym_name = o.object_name ) ) utc,