[Home] [Help]
878: AND g.source_application_id = o.application_id
879: AND og.object_name = o.object_name
880: AND EXISTS (
881: SELECT /*+ no_unnest */ 1 --added for bug13344804
882: FROM dba_tab_columns t,user_objects uo
883: WHERE og.owner = t.owner
884: AND o.object_name = t.table_name
885: AND uo.object_name = o.object_name
886: AND uo.object_type <> 'SYNONYM'
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
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
976: AND r.object_name = o.object_name
977: AND og.reference_object_name = r.reference_object_name
978: AND EXISTS (
979: SELECT /*+ no_unnest */ 1 --added for bug13344804
980: FROM dba_tab_columns t,user_objects uo
981: WHERE og.owner = t.owner
982: AND r.reference_object_name = t.table_name
983: AND uo.object_name = r.reference_object_name
984: AND uo.object_type <> 'SYNONYM'
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
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
1063: AND g.source_application_id = o.application_id
1064: AND og.object_name = o.object_name
1065: AND EXISTS (
1066: SELECT /*+ no_unnest */ 1 --added for bug13344804
1067: FROM dba_tab_columns t,user_objects uo
1068: WHERE og.owner = t.owner
1069: AND o.object_name = t.table_name
1070: AND uo.object_name = o.object_name
1071: AND uo.object_type <> 'SYNONYM'
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
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
1158: AND r.object_name = o.object_name
1159: AND og.reference_object_name = r.reference_object_name
1160: AND EXISTS (
1161: SELECT /*+ no_unnest */ 1 --added for bug13344804
1162: FROM dba_tab_columns t,user_objects uo
1163: WHERE og.owner = t.owner
1164: AND r.reference_object_name = t.table_name
1165: AND uo.object_name = r.reference_object_name
1166: AND uo.object_type <> 'SYNONYM'
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
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
1239: o.object_type_code extract_object_type,
1240: o.always_populated_flag extract_object_pop_flag,
1241: -- 4713242 Performance Fix
1242: (SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1243: FROM dba_tab_columns T,user_objects uo
1244: WHERE og.owner = t.owner
1245: AND uo.object_name = t.table_name
1246: AND uo.object_name = o.object_name
1247: AND uo.object_type <> 'SYNONYM'
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
1268: AND g.entity_code = p_entity_code
1269: AND g.event_class_code = p_event_class_code
1270: AND g.extract_object_name IS NULL
1271: AND EXISTS (SELECT /*+ no_unnest */ 1 --added for bug13344804
1272: FROM dba_tab_columns t,user_objects uo
1273: WHERE og.owner = t.owner
1274: AND o.object_name = t.table_name
1275: AND uo.object_name = o.object_name
1276: AND uo.object_type <> 'SYNONYM'
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
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
1345: ,o.object_type_code extract_object_type
1346: ,o.always_populated_flag extract_object_pop_flag
1347: -- 4713242 Performance Fix
1348: ,(SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1349: FROM dba_tab_columns T,user_objects uo
1350: WHERE og.owner = t.owner
1351: AND r.reference_object_name = t.table_name
1352: AND uo.object_name = r.reference_object_name
1353: AND uo.object_type <> 'SYNONYM'
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
1379: AND g.entity_code = p_entity_code
1380: AND g.event_class_code = p_event_class_code
1381: AND g.extract_object_name IS NULL
1382: AND EXISTS (SELECT /*+ no_unnest */ 1 --added for bug13344804
1383: FROM dba_tab_columns t,user_objects uo
1384: WHERE og.owner = t.owner
1385: AND r.reference_object_name = t.table_name
1386: AND uo.object_name = r.reference_object_name
1387: AND uo.object_type <> 'SYNONYM'
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
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
1822:
1823: CURSOR c_object_type
1824: IS
1825: SELECT usr.object_type
1826: FROM user_objects usr
1827: WHERE usr.object_name = l_object_name;
1828:
1829: CURSOR c_syn_owner
1830: IS
1894: ,owner)
1895: SELECT ext.object_name, l_user
1896: FROM xla_extract_objects ext
1897: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1898: FROM user_objects usr
1899: WHERE ext.object_name = usr.object_name
1900: AND usr.object_type <> 'SYNONYM' )
1901: AND ext.application_id = p_application_id
1902: AND entity_code = p_entity_code
1911: SELECT rfr.reference_object_name, l_user
1912: FROM xla_reference_objects rfr
1913: WHERE
1914: EXISTS (SELECT /*+ no_unnest */ 'c'
1915: FROM user_objects usr
1916: WHERE rfr.reference_object_name = usr.object_name
1917: AND usr.object_type <> 'SYNONYM' )
1918: AND rfr.application_id = p_application_id
1919: AND rfr.entity_code = p_entity_code
1925: (object_name
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')
1932: AND ext.object_name = syn.synonym_name
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')
1949: (reference_object_name
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
1957: AND rfr.reference_object_name = syn.synonym_name
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
2184: AND event_class_code = p_event_class_code
2185: AND extract_object_name IS NOT NULL
2186: AND extract_object_name = og.object_name
2187: AND NOT EXISTS (SELECT 'x'
2188: FROM dba_tab_columns t, user_objects uo
2189: WHERE t.table_name = og.object_name
2190: AND og.owner = t.owner
2191: AND uo.object_name = og.object_name
2192: AND uo.object_type <> 'SYNONYM'
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
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
2251: AND extract_object_name IS NOT NULL
2252: AND extract_object_type_code IN ('HEADER_MLS','LINE_MLS')
2253: AND extract_object_name = og.object_name
2254: AND NOT EXISTS (SELECT 'x'
2255: FROM dba_tab_columns t, user_objects uo
2256: WHERE t.table_name = og.object_name
2257: AND og.owner = t.owner
2258: AND uo.object_name = og.object_name
2259: AND uo.object_type <> 'SYNONYM'
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
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
2319: AND extract_object_name IS NOT NULL
2320: AND extract_object_type_code IN ('LINE','LINE_MLS')
2321: AND extract_object_name = og.object_name
2322: AND NOT EXISTS (SELECT 'x'
2323: FROM dba_tab_columns t, user_objects uo
2324: WHERE t.table_name = og.object_name
2325: AND og.owner = t.owner
2326: AND uo.object_name = og.object_name
2327: AND uo.object_type <> 'SYNONYM'
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
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
2389: AND e.extract_object_name = og.object_name
2390: AND e.application_id = app.application_id
2391: AND app.alc_enabled_flag = 'N'
2392: AND NOT EXISTS (SELECT 'x'
2393: FROM dba_tab_columns t, user_objects uo
2394: WHERE t.table_name = og.object_name
2395: AND og.owner = t.owner
2396: AND uo.object_name = og.object_name
2397: AND uo.object_type <> 'SYNONYM'
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
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
2454: AND entity_code = p_entity_code
2455: AND event_class_code = p_event_class_code
2456: AND e.object_name = og.object_name
2457: AND NOT EXISTS (SELECT 'x'
2458: FROM dba_tab_columns t, user_objects uo
2459: WHERE t.table_name = og.object_name
2460: AND og.owner = t.owner
2461: AND uo.object_name = og.object_name
2462: AND uo.object_type <> 'SYNONYM'
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
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
2525: AND event_class_code = p_event_class_code
2526: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
2527: AND e.object_name = og.object_name
2528: AND NOT EXISTS (SELECT 'x'
2529: FROM dba_tab_columns t, user_objects uo
2530: WHERE t.table_name = og.object_name
2531: AND og.owner = t.owner
2532: AND uo.object_name = og.object_name
2533: AND uo.object_type <> 'SYNONYM'
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
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
2596: AND event_class_code = p_event_class_code
2597: AND object_type_code IN ('LINE','LINE_MLS')
2598: AND e.object_name = og.object_name
2599: AND NOT EXISTS (SELECT 'x'
2600: FROM dba_tab_columns t, user_objects uo
2601: WHERE t.table_name = og.object_name
2602: AND og.owner = t.owner
2603: AND uo.object_name = og.object_name
2604: AND uo.object_type <> 'SYNONYM'
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
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
2669: AND e.object_name = og.object_name
2670: AND e.application_id = app.application_id
2671: AND app.alc_enabled_flag = 'N'
2672: AND NOT EXISTS (SELECT 'x'
2673: FROM dba_tab_columns t, user_objects uo
2674: WHERE t.table_name = og.object_name
2675: AND og.owner = t.owner
2676: AND uo.object_name = og.object_name
2677: AND uo.object_type <> 'SYNONYM'
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
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
3697: AND s.source_code = c.column_name); */
3698: CURSOR c_mls
3699: IS
3700: SELECT distinct c.column_name
3701: FROM dba_tab_columns c,user_objects uo,xla_extract_objects e, xla_extract_objects_gt og
3702: WHERE c.table_name = e.object_name
3703: AND uo.object_name = e.object_name
3704: AND uo.object_type <> 'SYNONYM'
3705: AND e.object_name = og.object_name
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
3736: WHEN 'HEADER' THEN 'N'
3737: WHEN 'LINE' THEN 'N'
3738: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3739: END translated_flag
3740: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
3741: WHERE c.table_name = e.object_name
3742: AND uo.object_name = e.object_name
3743: AND uo.object_type <> 'SYNONYM'
3744: AND e.object_name = og.object_name
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
3806: WHEN 'HEADER' THEN 'N'
3807: WHEN 'LINE' THEN 'N'
3808: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3809: END translated_flag
3810: FROM dba_tab_columns c,user_objects uo, xla_reference_objects r,
3811: xla_reference_objects_gt og, xla_extract_objects e
3812: WHERE c.table_name = r.reference_object_name
3813: AND uo.object_name = r.reference_object_name
3814: AND uo.object_type <> 'SYNONYM'
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
4725: ,g_created_by
4726: ,g_last_updated_by
4727: ,g_last_update_date
4728: ,g_last_update_login
4729: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
4730: WHERE c.table_name = e.object_name
4731: AND uo.object_name = e.object_name
4732: AND uo.object_type <> 'SYNONYM'
4733: AND og.object_name = e.object_name
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
4807: ,g_created_by
4808: ,g_last_updated_by
4809: ,g_last_update_date
4810: ,g_last_update_login
4811: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo,
4812: xla_reference_objects_gt og, xla_extract_objects e
4813: WHERE c.table_name = r.reference_object_name
4814: AND og.reference_object_name = r.reference_object_name
4815: AND og.owner = c.owner
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
4897: ,g_created_by
4898: ,g_last_updated_by
4899: ,g_last_update_date
4900: ,g_last_update_login
4901: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
4902: WHERE c.table_name = e.object_name
4903: AND uo.object_name = e.object_name
4904: AND uo.object_type <> 'SYNONYM'
4905: AND og.object_name = e.object_name
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
4979: ,g_created_by
4980: ,g_last_updated_by
4981: ,g_last_update_date
4982: ,g_last_update_login
4983: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo,
4984: xla_reference_objects_gt og, xla_extract_objects e
4985: WHERE c.table_name = r.reference_object_name
4986: AND uo.object_name = r.reference_object_name
4987: AND uo.object_type <> 'SYNONYM'
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
5070: ,g_created_by
5071: ,g_last_updated_by
5072: ,g_last_update_date
5073: ,g_last_update_login
5074: FROM dba_tab_columns c, user_objects uo,xla_extract_objects e, xla_extract_objects_gt og
5075: WHERE c.table_name = e.object_name
5076: AND uo.object_name = e.object_name
5077: AND uo.object_type <> 'SYNONYM'
5078: AND og.object_name = e.object_name
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
5152: ,g_created_by
5153: ,g_last_updated_by
5154: ,g_last_update_date
5155: ,g_last_update_login
5156: FROM dba_tab_columns c,user_objects uo, xla_reference_objects r,
5157: xla_reference_objects_gt og, xla_extract_objects e
5158: WHERE c.table_name = r.reference_object_name
5159: AND uo.object_name = r.reference_object_name
5160: AND uo.object_type <> 'SYNONYM'
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
5244: ,g_created_by
5245: ,g_last_updated_by
5246: ,g_last_update_date
5247: ,g_last_update_login
5248: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
5249: WHERE c.table_name = e.object_name
5250: AND uo.object_name = e.object_name
5251: AND uo.object_type <> 'SYNONYM'
5252: AND og.object_name = e.object_name
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
5326: ,g_created_by
5327: ,g_last_updated_by
5328: ,g_last_update_date
5329: ,g_last_update_login
5330: FROM dba_tab_columns c,user_objects uo, xla_reference_objects r,
5331: xla_reference_objects_gt og, xla_extract_objects e
5332: WHERE c.table_name = r.reference_object_name
5333: AND uo.object_name = r.reference_object_name
5334: AND uo.object_type <> 'SYNONYM'
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