DBA Data[Home] [Help]

APPS.XLA_REPORT_UTILITY_PKG dependencies on USER_OBJECTS

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 916: FROM user_synonyms s , user_objects o

912: SELECT dt.table_name, dt.column_name , dt.data_type
913: FROM dba_tab_columns dt
914: WHERE (dt.table_name , dt.owner)
915: IN ( SELECT s.table_name , s.table_owner
916: FROM user_synonyms s , user_objects o
917: WHERE 1 = 1
918: AND o.object_name = p_reporting_view_name
919: AND o.object_type = 'SYNONYM'
920: AND s.synonym_name = o.object_name ) ) utc,

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 1710: FROM user_synonyms s , user_objects o

1706: SELECT dt.table_name, dt.column_name , dt.data_type
1707: FROM dba_tab_columns dt
1708: WHERE (dt.table_name , dt.owner)
1709: IN ( SELECT s.table_name , s.table_owner
1710: FROM user_synonyms s , user_objects o
1711: WHERE 1 = 1
1712: AND o.object_name = cur_trx.reporting_view_name
1713: AND o.object_type = 'SYNONYM'
1714: AND s.synonym_name = o.object_name ) ) utc,

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

Line 1968: FROM user_synonyms s , user_objects o

1964: SELECT dt.table_name, dt.column_name , dt.data_type
1965: FROM dba_tab_columns dt
1966: WHERE (dt.table_name , dt.owner)
1967: IN ( SELECT s.table_name , s.table_owner
1968: FROM user_synonyms s , user_objects o
1969: WHERE 1 = 1
1970: AND o.object_name = cur_trx.reporting_view_name
1971: AND o.object_type = 'SYNONYM'
1972: AND s.synonym_name = o.object_name ) ) utc,