DBA Data[Home] [Help]

APPS.XLA_REPORT_UTILITY_PKG dependencies on DBA_TAB_COLUMNS

Line 913: FROM dba_tab_columns dt

909: AND o.object_name = p_reporting_view_name
910: AND o.object_type <> 'SYNONYM'
911: UNION ALL
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

Line 1707: FROM dba_tab_columns dt

1703: AND o.object_name = cur_trx.reporting_view_name
1704: AND o.object_type <> 'SYNONYM'
1705: UNION ALL
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

Line 1965: FROM dba_tab_columns dt

1961: AND o.object_name = cur_trx.reporting_view_name
1962: AND o.object_type <> 'SYNONYM'
1963: UNION ALL
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