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_EXTRACT_INTEGRITY_PKG dependencies on USER_SYNONYMS

Line 891: --FROM dba_tab_columns t,user_synonyms s,user_objects uo

887: AND t.column_name = g.source_code
888: AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE
889: UNION ALL
890: --SELECT /*+ no_unnest */ 1 --added for bug13344804
891: --FROM dba_tab_columns t,user_synonyms s,user_objects uo
892: --WHERE s.table_owner = t.owner
893: --AND s.table_name = t.table_name
894: --AND s.synonym_name =o.object_name
895: --AND uo.object_name = o.object_name

Line 900: FROM USER_SYNONYMS S,USER_OBJECTS UO

896: --AND uo.object_type = 'SYNONYM'
897: --AND t.column_name = g.source_code
898: --AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE
899: SELECT /*+ no_unnest */ 1
900: FROM USER_SYNONYMS S,USER_OBJECTS UO
901: WHERE 1=1
902: AND UO.OBJECT_NAME = O.OBJECT_NAME
903: AND UO.OBJECT_TYPE = 'SYNONYM'
904: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 989: --FROM dba_tab_columns t,user_synonyms s,user_objects uo

985: AND t.column_name = g.source_code
986: AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code
987: UNION ALL
988: --SELECT /*+ no_unnest */ 1 --added for bug13344804
989: --FROM dba_tab_columns t,user_synonyms s,user_objects uo
990: --WHERE s.table_owner = t.owner
991: --AND s.table_name = t.table_name
992: --AND s.synonym_name =r.reference_object_name
993: --AND uo.object_name = r.reference_object_name

Line 998: FROM USER_SYNONYMS S,USER_OBJECTS UO

994: --AND uo.object_type = 'SYNONYM'
995: --AND t.column_name = g.source_code
996: --AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code
997: SELECT /*+ no_unnest */ 1
998: FROM USER_SYNONYMS S,USER_OBJECTS UO
999: WHERE 1=1
1000: AND UO.OBJECT_NAME = r.reference_object_name
1001: AND UO.OBJECT_TYPE = 'SYNONYM'
1002: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 1076: --FROM dba_tab_columns t,user_synonyms s,user_objects uo

1072: AND t.column_name = g.source_code
1073: AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = g.source_datatype_code
1074: UNION ALL
1075: --SELECT /*+ no_unnest */ 1 --added for bug13344804
1076: --FROM dba_tab_columns t,user_synonyms s,user_objects uo
1077: --WHERE s.table_owner = t.owner
1078: --AND s.table_name = t.table_name
1079: --AND s.synonym_name =o.object_name
1080: --AND uo.object_name = o.object_name

Line 1085: FROM USER_SYNONYMS S,USER_OBJECTS UO

1081: --AND uo.object_type = 'SYNONYM'
1082: --AND t.column_name = g.source_code
1083: --AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = g.source_datatype_code
1084: SELECT /*+ no_unnest */ 1
1085: FROM USER_SYNONYMS S,USER_OBJECTS UO
1086: WHERE 1=1
1087: AND UO.OBJECT_NAME = o.object_name
1088: AND UO.OBJECT_TYPE = 'SYNONYM'
1089: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 1171: --FROM dba_tab_columns t,user_synonyms s,user_objects uo

1167: AND t.column_name = g.source_code
1168: AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code
1169: UNION ALL
1170: --SELECT /*+ no_unnest */ 1 --added for bug13344804
1171: --FROM dba_tab_columns t,user_synonyms s,user_objects uo
1172: --WHERE s.table_owner = t.owner
1173: --AND s.table_name = t.table_name
1174: --AND s.synonym_name =r.reference_object_name
1175: --AND uo.object_name = r.reference_object_name

Line 1180: FROM USER_SYNONYMS S,USER_OBJECTS UO

1176: --AND uo.object_type = 'SYNONYM'
1177: --AND t.column_name = g.source_code
1178: --AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code
1179: SELECT /*+ no_unnest */ 1
1180: FROM USER_SYNONYMS S,USER_OBJECTS UO
1181: WHERE 1=1
1182: AND UO.OBJECT_NAME = r.reference_object_name
1183: AND UO.OBJECT_TYPE = 'SYNONYM'
1184: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 1251: FROM dba_tab_columns T,user_objects uo,user_synonyms s

1247: AND uo.object_type <> 'SYNONYM'
1248: AND t.column_name = g.source_code
1249: UNION ALL
1250: SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1251: FROM dba_tab_columns T,user_objects uo,user_synonyms s
1252: WHERE t.table_name = s.table_name
1253: AND s.synonym_name = uo.object_name
1254: AND s.table_owner = t.owner
1255: AND uo.object_name = o.object_name

Line 1280: --FROM dba_tab_columns t,user_synonyms s,user_objects uo

1276: AND uo.object_type <> 'SYNONYM'
1277: AND t.column_name = g.source_code
1278: UNION ALL
1279: --SELECT /*+ no_unnest */ 1 --added for bug13344804
1280: --FROM dba_tab_columns t,user_synonyms s,user_objects uo
1281: --WHERE s.table_owner = t.owner
1282: --AND s.table_name = t.table_name
1283: --AND s.synonym_name =o.object_name
1284: --AND uo.object_name = o.object_name

Line 1288: FROM USER_SYNONYMS S,USER_OBJECTS UO

1284: --AND uo.object_name = o.object_name
1285: --AND uo.object_type = 'SYNONYM'
1286: --AND t.column_name = g.source_code
1287: SELECT /*+ no_unnest */ 1
1288: FROM USER_SYNONYMS S,USER_OBJECTS UO
1289: WHERE 1=1
1290: AND UO.OBJECT_NAME = o.object_name
1291: AND UO.OBJECT_TYPE = 'SYNONYM'
1292: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 1357: FROM dba_tab_columns T,user_objects uo,user_synonyms s

1353: AND uo.object_type <> 'SYNONYM'
1354: AND t.column_name = g.source_code
1355: UNION ALL
1356: SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1357: FROM dba_tab_columns T,user_objects uo,user_synonyms s
1358: WHERE s.table_owner = t.owner
1359: AND s.table_name = t.table_name
1360: AND s.synonym_name = uo.object_name
1361: AND uo.object_name = r.reference_object_name

Line 1391: --FROM dba_tab_columns t,user_synonyms s,user_objects uo

1387: AND uo.object_type <> 'SYNONYM'
1388: AND t.column_name = g.source_code
1389: UNION ALL
1390: --SELECT /*+ no_unnest */ 1 --added for bug13344804
1391: --FROM dba_tab_columns t,user_synonyms s,user_objects uo
1392: --WHERE s.table_owner = t.owner
1393: --AND s.table_name = t.table_name
1394: --AND s.synonym_name =r.reference_object_name
1395: --AND uo.object_name = r.reference_object_name

Line 1399: FROM USER_SYNONYMS S,USER_OBJECTS UO

1395: --AND uo.object_name = r.reference_object_name
1396: --AND uo.object_type = 'SYNONYM'
1397: --AND t.column_name = g.source_code
1398: SELECT /*+ no_unnest */ 1
1399: FROM USER_SYNONYMS S,USER_OBJECTS UO
1400: WHERE 1=1
1401: AND UO.OBJECT_NAME = r.reference_object_name
1402: AND UO.OBJECT_TYPE = 'SYNONYM'
1403: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 1832: FROM user_synonyms syn

1828:
1829: CURSOR c_syn_owner
1830: IS
1831: SELECT syn.table_owner
1832: FROM user_synonyms syn
1833: WHERE syn.synonym_name = l_object_name;
1834:
1835: BEGIN
1836:

Line 1930: ,user_synonyms syn

1926: ,owner)
1927: SELECT ext.object_name
1928: ,(SELECT syn.table_owner
1929: FROM user_objects usr
1930: ,user_synonyms syn
1931: WHERE ext.object_name = usr.object_name
1932: AND ext.object_name = syn.synonym_name
1933: AND usr.object_type = 'SYNONYM')
1934: FROM xla_extract_objects ext

Line 1937: ,user_synonyms syn

1933: AND usr.object_type = 'SYNONYM')
1934: FROM xla_extract_objects ext
1935: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1936: FROM user_objects usr
1937: ,user_synonyms syn
1938: WHERE ext.object_name = usr.object_name
1939: AND ext.object_name = syn.synonym_name
1940: AND usr.object_type = 'SYNONYM')
1941: AND ext.application_id = p_application_id

Line 1954: ,user_synonyms syn

1950: ,owner)
1951: SELECT rfr.reference_object_name
1952: ,(SELECT syn.table_owner
1953: FROM user_objects usr
1954: ,user_synonyms syn
1955: -- change rfr.object_name to rfr.reference_object_name, as told by dimple
1956: WHERE rfr.reference_object_name = usr.object_name
1957: AND rfr.reference_object_name = syn.synonym_name
1958: AND usr.object_type = 'SYNONYM')

Line 1962: ,user_synonyms syn

1958: AND usr.object_type = 'SYNONYM')
1959: FROM xla_reference_objects rfr
1960: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1961: FROM user_objects usr
1962: ,user_synonyms syn
1963: -- change rfr.object_name to rfr.reference_object_name, as told by dimple
1964: WHERE rfr.reference_object_name = usr.object_name
1965: AND rfr.reference_object_name = syn.synonym_name
1966: AND usr.object_type = 'SYNONYM')

Line 2197: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2193: AND t.column_name = 'EVENT_ID'
2194: AND t.data_type = 'NUMBER'
2195: UNION ALL
2196: --SELECT 'x'
2197: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2198: -- WHERE s.table_owner = t.owner
2199: -- AND s.table_name = t.table_name
2200: -- AND s.synonym_name =og.object_name
2201: -- AND uo.object_name = og.object_name

Line 2206: FROM USER_SYNONYMS S,USER_OBJECTS UO

2202: -- AND uo.object_type = 'SYNONYM'
2203: -- AND t.column_name = 'EVENT_ID'
2204: -- AND t.data_type = 'NUMBER'
2205: SELECT /*+ no_unnest */ 'x'
2206: FROM USER_SYNONYMS S,USER_OBJECTS UO
2207: WHERE 1=1
2208: AND UO.OBJECT_NAME = og.object_name
2209: AND UO.OBJECT_TYPE = 'SYNONYM'
2210: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2264: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2260: AND t.column_name = 'LANGUAGE'
2261: AND t.data_type = 'VARCHAR2'
2262: UNION ALL
2263: --SELECT 'x'
2264: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2265: -- WHERE s.table_owner = t.owner
2266: -- AND s.table_name = t.table_name
2267: -- AND s.synonym_name =og.object_name
2268: -- AND uo.object_name = og.object_name

Line 2273: FROM USER_SYNONYMS S,USER_OBJECTS UO

2269: -- AND uo.object_type = 'SYNONYM'
2270: -- AND t.column_name = 'LANGUAGE'
2271: -- AND t.data_type = 'VARCHAR2'
2272: SELECT /*+ no_unnest */ 'x'
2273: FROM USER_SYNONYMS S,USER_OBJECTS UO
2274: WHERE 1=1
2275: AND UO.OBJECT_NAME = og.object_name
2276: AND UO.OBJECT_TYPE = 'SYNONYM'
2277: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2332: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2328: AND t.column_name = 'LINE_NUMBER'
2329: AND t.data_type = 'NUMBER'
2330: UNION ALL
2331: --SELECT 'x'
2332: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2333: -- WHERE s.table_owner = t.owner
2334: -- AND s.table_name = t.table_name
2335: -- AND s.synonym_name =og.object_name
2336: -- AND uo.object_name = og.object_name

Line 2341: FROM USER_SYNONYMS S,USER_OBJECTS UO

2337: -- AND uo.object_type = 'SYNONYM'
2338: -- AND t.column_name = 'LINE_NUMBER'
2339: -- AND t.data_type = 'NUMBER'
2340: SELECT /*+ no_unnest */ 'x'
2341: FROM USER_SYNONYMS S,USER_OBJECTS UO
2342: WHERE 1=1
2343: AND UO.OBJECT_NAME = og.object_name
2344: AND UO.OBJECT_TYPE = 'SYNONYM'
2345: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2402: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2398: AND t.column_name = 'LEDGER_ID'
2399: AND t.data_type = 'NUMBER'
2400: UNION ALL
2401: --SELECT 'x'
2402: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2403: -- WHERE s.table_owner = t.owner
2404: -- AND s.table_name = t.table_name
2405: -- AND s.synonym_name =og.object_name
2406: -- AND uo.object_name = og.object_name

Line 2411: FROM USER_SYNONYMS S,USER_OBJECTS UO

2407: -- AND uo.object_type = 'SYNONYM'
2408: -- AND t.column_name = 'LEDGER_ID'
2409: -- AND t.data_type = 'NUMBER'
2410: SELECT /*+ no_unnest */ 'x'
2411: FROM USER_SYNONYMS S,USER_OBJECTS UO
2412: WHERE 1=1
2413: AND UO.OBJECT_NAME = og.object_name
2414: AND UO.OBJECT_TYPE = 'SYNONYM'
2415: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2467: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2463: AND t.column_name = 'EVENT_ID'
2464: AND t.data_type = 'NUMBER'
2465: UNION ALL
2466: --SELECT 'x'
2467: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2468: -- WHERE s.table_owner = t.owner
2469: -- AND s.table_name = t.table_name
2470: -- AND s.synonym_name =og.object_name
2471: -- AND uo.object_name = og.object_name

Line 2476: FROM USER_SYNONYMS S,USER_OBJECTS UO

2472: -- AND uo.object_type = 'SYNONYM'
2473: -- AND t.column_name = 'EVENT_ID'
2474: -- AND t.data_type = 'NUMBER'
2475: SELECT /*+ no_unnest */ 'x'
2476: FROM USER_SYNONYMS S,USER_OBJECTS UO
2477: WHERE 1=1
2478: AND UO.OBJECT_NAME = og.object_name
2479: AND UO.OBJECT_TYPE = 'SYNONYM'
2480: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2538: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2534: AND t.column_name = 'LANGUAGE'
2535: AND t.data_type = 'VARCHAR2'
2536: UNION ALL
2537: --SELECT 'x'
2538: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2539: -- WHERE s.table_owner = t.owner
2540: -- AND s.table_name = t.table_name
2541: -- AND s.synonym_name =og.object_name
2542: -- AND uo.object_name = og.object_name

Line 2547: FROM USER_SYNONYMS S,USER_OBJECTS UO

2543: -- AND uo.object_type = 'SYNONYM'
2544: -- AND t.column_name = 'LANGUAGE'
2545: -- AND t.data_type = 'VARCHAR2'
2546: SELECT /*+ no_unnest */ 'x'
2547: FROM USER_SYNONYMS S,USER_OBJECTS UO
2548: WHERE 1=1
2549: AND UO.OBJECT_NAME = og.object_name
2550: AND UO.OBJECT_TYPE = 'SYNONYM'
2551: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2609: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2605: AND t.column_name = 'LINE_NUMBER'
2606: AND t.data_type = 'NUMBER'
2607: UNION ALL
2608: --SELECT 'x'
2609: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2610: -- WHERE s.table_owner = t.owner
2611: -- AND s.table_name = t.table_name
2612: -- AND s.synonym_name =og.object_name
2613: -- AND uo.object_name = og.object_name

Line 2618: FROM USER_SYNONYMS S,USER_OBJECTS UO

2614: -- AND uo.object_type = 'SYNONYM'
2615: -- AND t.column_name = 'LINE_NUMBER'
2616: -- AND t.data_type = 'NUMBER'
2617: SELECT /*+ no_unnest */ 'x'
2618: FROM USER_SYNONYMS S,USER_OBJECTS UO
2619: WHERE 1=1
2620: AND UO.OBJECT_NAME = og.object_name
2621: AND UO.OBJECT_TYPE = 'SYNONYM'
2622: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 2682: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo

2678: AND t.column_name = 'LEDGER_ID'
2679: AND t.data_type = 'NUMBER'
2680: UNION ALL
2681: --SELECT 'x'
2682: -- FROM dba_tab_columns t,user_synonyms s,user_objects uo
2683: -- WHERE s.table_owner = t.owner
2684: -- AND s.table_name = t.table_name
2685: -- AND s.synonym_name =og.object_name
2686: -- AND uo.object_name = og.object_name

Line 2691: FROM USER_SYNONYMS S,USER_OBJECTS UO

2687: -- AND uo.object_type = 'SYNONYM'
2688: -- AND t.column_name = 'LEDGER_ID'
2689: -- AND t.data_type = 'NUMBER'
2690: SELECT /*+ no_unnest */ 'x'
2691: FROM USER_SYNONYMS S,USER_OBJECTS UO
2692: WHERE 1=1
2693: AND UO.OBJECT_NAME = og.object_name
2694: AND UO.OBJECT_TYPE = 'SYNONYM'
2695: AND S.SYNONYM_NAME = UO.OBJECT_NAME

Line 3715: FROM dba_tab_columns c,user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og

3711: AND c.data_type IN ('NUMBER','DATE')
3712: AND c.column_name NOT IN ('EVENT_ID','LINE_NUMBER','LEDGER_ID')
3713: UNION ALL
3714: SELECT distinct c.column_name
3715: FROM dba_tab_columns c,user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
3716: WHERE s.table_owner = c.owner
3717: AND s.table_name = c.table_name
3718: AND s.synonym_name = e.object_name
3719: AND uo.object_name = e.object_name

Line 3773: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_extract_objects e, xla_extract_objects_gt og

3769: WHEN 'HEADER' THEN 'N'
3770: WHEN 'LINE' THEN 'N'
3771: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3772: END translated_flag
3773: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_extract_objects e, xla_extract_objects_gt og
3774: WHERE s.table_owner = c.owner
3775: AND c.table_name = s.table_name
3776: AND uo.object_name = s.synonym_name
3777: AND uo.object_name =e.object_name

Line 3849: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_reference_objects r,

3845: WHEN 'HEADER' THEN 'N'
3846: WHEN 'LINE' THEN 'N'
3847: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3848: END translated_flag
3849: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_reference_objects r,
3850: xla_reference_objects_gt og, xla_extract_objects e
3851: WHERE s.table_owner = c.owner
3852: AND c.table_name = s.table_name
3853: AND uo.object_name = s.synonym_name

Line 4761: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_extract_objects e, xla_extract_objects_gt og

4757: ,g_created_by
4758: ,g_last_updated_by
4759: ,g_last_update_date
4760: ,g_last_update_login
4761: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_extract_objects e, xla_extract_objects_gt og
4762: WHERE s.table_owner = c.owner
4763: AND c.table_name = s.table_name
4764: AND uo.object_name = s.synonym_name
4765: AND uo.object_name = e.object_name

Line 4848: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo, user_synonyms s,xla_reference_objects_gt og, xla_extract_objects e

4844: ,g_created_by
4845: ,g_last_updated_by
4846: ,g_last_update_date
4847: ,g_last_update_login
4848: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo, user_synonyms s,xla_reference_objects_gt og, xla_extract_objects e
4849: WHERE c.table_name = s.table_name
4850: AND og.reference_object_name = r.reference_object_name
4851: AND s.table_owner = c.owner
4852: AND uo.object_name = s.synonym_name

Line 4933: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og

4929: ,g_created_by
4930: ,g_last_updated_by
4931: ,g_last_update_date
4932: ,g_last_update_login
4933: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
4934: WHERE s.table_owner = c.owner
4935: AND c.table_name = s.table_name
4936: AND uo.object_name = s.synonym_name
4937: AND uo.object_name = e.object_name

Line 5020: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo,user_synonyms s,

5016: ,g_created_by
5017: ,g_last_updated_by
5018: ,g_last_update_date
5019: ,g_last_update_login
5020: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo,user_synonyms s,
5021: xla_reference_objects_gt og, xla_extract_objects e
5022: WHERE c.table_name = s.table_name
5023: AND uo.object_name = s.synonym_name
5024: AND uo.object_name = r.reference_object_name

Line 5106: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og

5102: ,g_created_by
5103: ,g_last_updated_by
5104: ,g_last_update_date
5105: ,g_last_update_login
5106: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
5107: WHERE s.table_owner = c.owner
5108: AND c.table_name = s.table_name
5109: AND uo.object_name = s.synonym_name
5110: AND uo.object_name = e.object_name

Line 5193: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_reference_objects r,

5189: ,g_created_by
5190: ,g_last_updated_by
5191: ,g_last_update_date
5192: ,g_last_update_login
5193: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_reference_objects r,
5194: xla_reference_objects_gt og, xla_extract_objects e
5195: WHERE s.table_owner = c.owner
5196: AND c.table_name = s.table_name
5197: AND uo.object_name = s.synonym_name

Line 5280: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og

5276: ,g_created_by
5277: ,g_last_updated_by
5278: ,g_last_update_date
5279: ,g_last_update_login
5280: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
5281: WHERE s.table_owner = c.owner
5282: AND c.table_name = s.table_name
5283: AND uo.object_name = s.synonym_name
5284: AND uo.object_name = e.object_name

Line 5368: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_reference_objects r,

5364: ,g_created_by
5365: ,g_last_updated_by
5366: ,g_last_update_date
5367: ,g_last_update_login
5368: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_reference_objects r,
5369: xla_reference_objects_gt og, xla_extract_objects e
5370: WHERE s.table_owner = c.owner
5371: AND c.table_name = s.table_name
5372: AND uo.object_name = s.synonym_name