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 DBA_TAB_COLUMNS

Line 853: /* FROM dba_tab_columns t

849: AND g.source_application_id = o.application_id
850: AND og.object_name = o.object_name
851: AND EXISTS (
852: -- SELECT /*+ no_unnest */ --1 --added for bug13344804
853: /* FROM dba_tab_columns t
854: WHERE og.owner = t.owner
855: AND o.object_name = t.table_name
856: AND t.column_name = g.source_code
857: AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE

Line 882: FROM dba_tab_columns t,user_objects uo

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'

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 906: from DBA_TAB_COLUMNS T

902: AND UO.OBJECT_NAME = O.OBJECT_NAME
903: AND UO.OBJECT_TYPE = 'SYNONYM'
904: AND S.SYNONYM_NAME = UO.OBJECT_NAME
905: AND exists (select /*+ no_unnest */ 'x'
906: from DBA_TAB_COLUMNS T
907: where S.TABLE_OWNER = T.OWNER
908: AND S.TABLE_NAME = T.TABLE_NAME
909: AND T.COLUMN_NAME = G.SOURCE_CODE
910: and DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE

Line 947: /* FROM dba_tab_columns t

943: AND r.object_name = o.object_name
944: AND og.reference_object_name = r.reference_object_name
945: AND EXISTS (
946: -- SELECT /*+ no_unnest */-- 1 --added for bug13344804
947: /* FROM dba_tab_columns t
948: WHERE og.owner = t.owner
949: AND r.reference_object_name = t.table_name
950: AND t.column_name = g.source_code
951: AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code

Line 980: FROM dba_tab_columns t,user_objects uo

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'

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 1004: from DBA_TAB_COLUMNS T

1000: AND UO.OBJECT_NAME = r.reference_object_name
1001: AND UO.OBJECT_TYPE = 'SYNONYM'
1002: AND S.SYNONYM_NAME = UO.OBJECT_NAME
1003: AND exists (select /*+ no_unnest */ 'x'
1004: from DBA_TAB_COLUMNS T
1005: where S.TABLE_OWNER = T.OWNER
1006: AND S.TABLE_NAME = T.TABLE_NAME
1007: AND T.COLUMN_NAME = G.SOURCE_CODE
1008: and DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE

Line 1040: /* FROM dba_tab_columns t

1036: AND g.source_application_id = o.application_id
1037: AND og.object_name = o.object_name
1038: AND EXISTS (
1039: -- SELECT /*+ no_unnest */-- 1 --added for bug13344804
1040: /* FROM dba_tab_columns t
1041: WHERE og.owner = t.owner
1042: AND o.object_name = t.table_name
1043: AND t.column_name = g.source_code
1044: AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = g.source_datatype_code

Line 1067: FROM dba_tab_columns t,user_objects uo

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'

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 1091: from DBA_TAB_COLUMNS T

1087: AND UO.OBJECT_NAME = o.object_name
1088: AND UO.OBJECT_TYPE = 'SYNONYM'
1089: AND S.SYNONYM_NAME = UO.OBJECT_NAME
1090: AND exists (select /*+ no_unnest */ 'x'
1091: from DBA_TAB_COLUMNS T
1092: where S.TABLE_OWNER = T.OWNER
1093: AND S.TABLE_NAME = T.TABLE_NAME
1094: AND T.COLUMN_NAME = G.SOURCE_CODE
1095: and DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE

Line 1130: /* FROM dba_tab_columns t

1126: AND r.object_name = o.object_name
1127: AND og.reference_object_name = r.reference_object_name
1128: AND EXISTS (
1129: -- SELECT /*+ no_unnest */ --1 --added for bug13344804
1130: /* FROM dba_tab_columns t
1131: WHERE og.owner = t.owner
1132: AND r.reference_object_name = t.table_name
1133: AND t.column_name = g.source_code
1134: AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code

Line 1162: FROM dba_tab_columns t,user_objects uo

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'

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 1186: from DBA_TAB_COLUMNS T

1182: AND UO.OBJECT_NAME = r.reference_object_name
1183: AND UO.OBJECT_TYPE = 'SYNONYM'
1184: AND S.SYNONYM_NAME = UO.OBJECT_NAME
1185: AND exists (select /*+ no_unnest */ 'x'
1186: from DBA_TAB_COLUMNS T
1187: where S.TABLE_OWNER = T.OWNER
1188: AND S.TABLE_NAME = T.TABLE_NAME
1189: AND T.COLUMN_NAME = G.SOURCE_CODE
1190: and DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE

Line 1212: FROM dba_tab_columns T

1208: o.object_type_code extract_object_type,
1209: o.always_populated_flag extract_object_pop_flag,
1210: -- 4713242 Performance Fix
1211: (SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1212: FROM dba_tab_columns T
1213: WHERE og.owner = t.owner
1214: AND o.object_name = t.table_name
1215: AND t.column_name = g.source_code)
1216: FROM xla_evt_class_sources_gt g, xla_extract_objects o,

Line 1229: /* FROM dba_tab_columns t

1225: AND g.entity_code = p_entity_code
1226: AND g.event_class_code = p_event_class_code
1227: AND g.extract_object_name IS NULL
1228: AND EXISTS (SELECT /*+ no_unnest */-- 1 --added for bug13344804
1229: /* FROM dba_tab_columns t
1230: WHERE og.owner = t.owner
1231: AND o.object_name = t.table_name
1232: AND t.column_name = g.source_code); */
1233:

Line 1243: FROM dba_tab_columns T,user_objects uo

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'

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 1272: FROM dba_tab_columns t,user_objects uo

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'

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 1294: from DBA_TAB_COLUMNS T

1290: AND UO.OBJECT_NAME = o.object_name
1291: AND UO.OBJECT_TYPE = 'SYNONYM'
1292: AND S.SYNONYM_NAME = UO.OBJECT_NAME
1293: AND exists (select /*+ no_unnest */ 'x'
1294: from DBA_TAB_COLUMNS T
1295: where S.TABLE_OWNER = T.OWNER
1296: AND S.TABLE_NAME = T.TABLE_NAME
1297: AND T.COLUMN_NAME = G.SOURCE_CODE
1298: )

Line 1313: FROM dba_tab_columns T

1309: ,o.object_type_code extract_object_type
1310: ,o.always_populated_flag extract_object_pop_flag
1311: -- 4713242 Performance Fix
1312: ,(SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1313: FROM dba_tab_columns T
1314: WHERE og.owner = t.owner
1315: AND r.reference_object_name = t.table_name
1316: AND t.column_name = g.source_code)
1317: ,r.join_condition

Line 1336: /* FROM dba_tab_columns t

1332: AND g.entity_code = p_entity_code
1333: AND g.event_class_code = p_event_class_code
1334: AND g.extract_object_name IS NULL
1335: AND EXISTS (SELECT /*+ no_unnest */-- 1 --added for bug13344804
1336: /* FROM dba_tab_columns t
1337: WHERE og.owner = t.owner
1338: AND r.reference_object_name = t.table_name
1339: AND t.column_name = g.source_code); */
1340: CURSOR c_ref_diff_datatype

Line 1349: FROM dba_tab_columns T,user_objects uo

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'

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 1383: FROM dba_tab_columns t,user_objects uo

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'

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 1405: from DBA_TAB_COLUMNS T

1401: AND UO.OBJECT_NAME = r.reference_object_name
1402: AND UO.OBJECT_TYPE = 'SYNONYM'
1403: AND S.SYNONYM_NAME = UO.OBJECT_NAME
1404: AND exists (select /*+ no_unnest */ 'x'
1405: from DBA_TAB_COLUMNS T
1406: where S.TABLE_OWNER = T.OWNER
1407: AND S.TABLE_NAME = T.TABLE_NAME
1408: AND T.COLUMN_NAME = G.SOURCE_CODE
1409: )

Line 2171: FROM dba_tab_columns t

2167: AND event_class_code = p_event_class_code
2168: AND extract_object_name IS NOT NULL
2169: AND extract_object_name = og.object_name
2170: AND NOT EXISTS (SELECT 'x'
2171: FROM dba_tab_columns t
2172: WHERE t.table_name = og.object_name
2173: AND og.owner = t.owner
2174: AND t.column_name = 'EVENT_ID'
2175: AND t.data_type = 'NUMBER');

Line 2188: FROM dba_tab_columns t, user_objects uo

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'

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 2212: from DBA_TAB_COLUMNS T

2208: AND UO.OBJECT_NAME = og.object_name
2209: AND UO.OBJECT_TYPE = 'SYNONYM'
2210: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2211: AND exists (select /*+ no_unnest */ 'x'
2212: from DBA_TAB_COLUMNS T
2213: where S.TABLE_OWNER = T.OWNER
2214: AND S.TABLE_NAME = T.TABLE_NAME
2215: AND T.COLUMN_NAME = 'EVENT_ID'
2216: and t.data_type = 'NUMBER'

Line 2238: FROM dba_tab_columns t

2234: AND extract_object_name IS NOT NULL
2235: AND extract_object_type_code IN ('HEADER_MLS','LINE_MLS')
2236: AND extract_object_name = og.object_name
2237: AND NOT EXISTS (SELECT 'x'
2238: FROM dba_tab_columns t
2239: WHERE t.table_name = og.object_name
2240: AND og.owner = t.owner
2241: AND t.column_name = 'LANGUAGE'
2242: AND t.data_type = 'VARCHAR2');

Line 2255: FROM dba_tab_columns t, user_objects uo

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'

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 2279: from DBA_TAB_COLUMNS T

2275: AND UO.OBJECT_NAME = og.object_name
2276: AND UO.OBJECT_TYPE = 'SYNONYM'
2277: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2278: AND exists (select /*+ no_unnest */ 'x'
2279: from DBA_TAB_COLUMNS T
2280: where S.TABLE_OWNER = T.OWNER
2281: AND S.TABLE_NAME = T.TABLE_NAME
2282: AND T.COLUMN_NAME = 'LANGUAGE'
2283: and t.data_type = 'VARCHAR2'

Line 2306: FROM dba_tab_columns t

2302: AND extract_object_name IS NOT NULL
2303: AND extract_object_type_code IN ('LINE','LINE_MLS')
2304: AND extract_object_name = og.object_name
2305: AND NOT EXISTS (SELECT 'x'
2306: FROM dba_tab_columns t
2307: WHERE t.table_name = og.object_name
2308: AND og.owner = t.owner
2309: AND t.column_name = 'LINE_NUMBER'
2310: AND t.data_type = 'NUMBER');

Line 2323: FROM dba_tab_columns t, user_objects uo

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'

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 2347: from DBA_TAB_COLUMNS T

2343: AND UO.OBJECT_NAME = og.object_name
2344: AND UO.OBJECT_TYPE = 'SYNONYM'
2345: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2346: AND exists (select /*+ no_unnest */ 'x'
2347: from DBA_TAB_COLUMNS T
2348: where S.TABLE_OWNER = T.OWNER
2349: AND S.TABLE_NAME = T.TABLE_NAME
2350: AND T.COLUMN_NAME = 'LINE_NUMBER'
2351: and t.data_type = 'NUMBER'

Line 2375: FROM dba_tab_columns t

2371: AND e.extract_object_name = og.object_name
2372: AND e.application_id = app.application_id
2373: AND app.alc_enabled_flag = 'N'
2374: AND NOT EXISTS (SELECT 'x'
2375: FROM dba_tab_columns t
2376: WHERE t.table_name = og.object_name
2377: AND og.owner = t.owner
2378: AND t.column_name = 'LEDGER_ID'
2379: AND t.data_type = 'NUMBER'); */

Line 2393: FROM dba_tab_columns t, user_objects uo

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'

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 2417: from DBA_TAB_COLUMNS T

2413: AND UO.OBJECT_NAME = og.object_name
2414: AND UO.OBJECT_TYPE = 'SYNONYM'
2415: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2416: AND exists (select /*+ no_unnest */ 'x'
2417: from DBA_TAB_COLUMNS T
2418: where S.TABLE_OWNER = T.OWNER
2419: AND S.TABLE_NAME = T.TABLE_NAME
2420: AND T.COLUMN_NAME = 'LEDGER_ID'
2421: and t.data_type = 'NUMBER'

Line 2440: FROM dba_tab_columns t

2436: AND entity_code = p_entity_code
2437: AND event_class_code = p_event_class_code
2438: AND e.object_name = og.object_name
2439: AND NOT EXISTS (SELECT 'x'
2440: FROM dba_tab_columns t
2441: WHERE t.table_name = og.object_name
2442: AND og.owner = t.owner
2443: AND t.column_name = 'EVENT_ID'
2444: AND t.data_type = 'NUMBER')

Line 2458: FROM dba_tab_columns t, user_objects uo

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'

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 2482: from DBA_TAB_COLUMNS T

2478: AND UO.OBJECT_NAME = og.object_name
2479: AND UO.OBJECT_TYPE = 'SYNONYM'
2480: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2481: AND exists (select /*+ no_unnest */ 'x'
2482: from DBA_TAB_COLUMNS T
2483: where S.TABLE_OWNER = T.OWNER
2484: AND S.TABLE_NAME = T.TABLE_NAME
2485: AND T.COLUMN_NAME = 'EVENT_ID'
2486: and t.data_type = 'NUMBER'

Line 2510: FROM dba_tab_columns t

2506: AND event_class_code = p_event_class_code
2507: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
2508: AND e.object_name = og.object_name
2509: AND NOT EXISTS (SELECT 'x'
2510: FROM dba_tab_columns t
2511: WHERE t.table_name = og.object_name
2512: AND og.owner = t.owner
2513: AND t.column_name = 'LANGUAGE'
2514: AND t.data_type = 'VARCHAR2')

Line 2529: FROM dba_tab_columns t, user_objects uo

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'

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 2553: from DBA_TAB_COLUMNS T

2549: AND UO.OBJECT_NAME = og.object_name
2550: AND UO.OBJECT_TYPE = 'SYNONYM'
2551: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2552: AND exists (select /*+ no_unnest */ 'x'
2553: from DBA_TAB_COLUMNS T
2554: where S.TABLE_OWNER = T.OWNER
2555: AND S.TABLE_NAME = T.TABLE_NAME
2556: AND T.COLUMN_NAME = 'LANGUAGE'
2557: and t.data_type = 'VARCHAR2'

Line 2581: FROM dba_tab_columns t

2577: AND event_class_code = p_event_class_code
2578: AND object_type_code IN ('LINE','LINE_MLS')
2579: AND e.object_name = og.object_name
2580: AND NOT EXISTS (SELECT 'x'
2581: FROM dba_tab_columns t
2582: WHERE t.table_name = og.object_name
2583: AND og.owner = t.owner
2584: AND t.column_name = 'LINE_NUMBER'
2585: AND t.data_type = 'NUMBER')

Line 2600: FROM dba_tab_columns t, user_objects uo

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'

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 2624: from DBA_TAB_COLUMNS T

2620: AND UO.OBJECT_NAME = og.object_name
2621: AND UO.OBJECT_TYPE = 'SYNONYM'
2622: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2623: AND exists (select /*+ no_unnest */ 'x'
2624: from DBA_TAB_COLUMNS T
2625: where S.TABLE_OWNER = T.OWNER
2626: AND S.TABLE_NAME = T.TABLE_NAME
2627: AND T.COLUMN_NAME = 'LINE_NUMBER'
2628: and t.data_type = 'NUMBER'

Line 2653: FROM dba_tab_columns t

2649: AND e.object_name = og.object_name
2650: AND e.application_id = app.application_id
2651: AND app.alc_enabled_flag = 'N'
2652: AND NOT EXISTS (SELECT 'x'
2653: FROM dba_tab_columns t
2654: WHERE t.table_name = og.object_name
2655: AND og.owner = t.owner
2656: AND t.column_name = 'LEDGER_ID'
2657: AND t.data_type = 'NUMBER')

Line 2673: FROM dba_tab_columns t, user_objects uo

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'

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 2697: from DBA_TAB_COLUMNS T

2693: AND UO.OBJECT_NAME = og.object_name
2694: AND UO.OBJECT_TYPE = 'SYNONYM'
2695: AND S.SYNONYM_NAME = UO.OBJECT_NAME
2696: AND exists (select /*+ no_unnest */ 'x'
2697: from DBA_TAB_COLUMNS T
2698: where S.TABLE_OWNER = T.OWNER
2699: AND S.TABLE_NAME = T.TABLE_NAME
2700: AND T.COLUMN_NAME = 'LEDGER_ID'
2701: and t.data_type = 'NUMBER'

Line 3616: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og

3612: /*
3613: CURSOR c_mls
3614: IS
3615: SELECT distinct c.column_name
3616: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3617: WHERE c.table_name = e.object_name
3618: AND e.object_name = og.object_name
3619: AND og.owner = c.owner
3620: AND e.application_id = p_application_id

Line 3637: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og

3633: WHEN 'HEADER' THEN 'N'
3634: WHEN 'LINE' THEN 'N'
3635: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3636: END translated_flag
3637: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3638: WHERE c.table_name = e.object_name
3639: AND e.object_name = og.object_name
3640: AND og.owner = c.owner
3641: --

Line 3671: FROM dba_tab_columns c, xla_reference_objects r,

3667: WHEN 'HEADER' THEN 'N'
3668: WHEN 'LINE' THEN 'N'
3669: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3670: END translated_flag
3671: FROM dba_tab_columns c, xla_reference_objects r,
3672: xla_reference_objects_gt og, xla_extract_objects e
3673: WHERE c.table_name = r.reference_object_name
3674: AND r.reference_object_name = og.reference_object_name
3675: AND og.owner = c.owner

Line 3701: FROM dba_tab_columns c,user_objects uo,xla_extract_objects e, xla_extract_objects_gt og

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

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 3740: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og

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

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 3810: FROM dba_tab_columns c,user_objects uo, xla_reference_objects r,

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'

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 4342: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og

4338: ,g_created_by
4339: ,g_last_updated_by
4340: ,g_last_update_date
4341: ,g_last_update_login
4342: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4343: WHERE c.table_name = e.object_name
4344: AND og.object_name = e.object_name
4345: AND og.owner = c.owner
4346: AND e.object_type_code IN ('HEADER','HEADER_MLS')

Line 4388: FROM dba_tab_columns c, xla_reference_objects r,

4384: ,g_created_by
4385: ,g_last_updated_by
4386: ,g_last_update_date
4387: ,g_last_update_login
4388: FROM dba_tab_columns c, xla_reference_objects r,
4389: xla_reference_objects_gt og, xla_extract_objects e
4390: WHERE c.table_name = r.reference_object_name
4391: AND og.reference_object_name = r.reference_object_name
4392: AND og.owner = c.owner

Line 4439: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og

4435: ,g_created_by
4436: ,g_last_updated_by
4437: ,g_last_update_date
4438: ,g_last_update_login
4439: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4440: WHERE c.table_name = e.object_name
4441: AND og.object_name = e.object_name
4442: AND og.owner = c.owner
4443: AND e.object_type_code IN ('LINE','LINE_MLS')

Line 4485: FROM dba_tab_columns c, xla_reference_objects r,

4481: ,g_created_by
4482: ,g_last_updated_by
4483: ,g_last_update_date
4484: ,g_last_update_login
4485: FROM dba_tab_columns c, xla_reference_objects r,
4486: xla_reference_objects_gt og, xla_extract_objects e
4487: WHERE c.table_name = r.reference_object_name
4488: AND og.reference_object_name = r.reference_object_name
4489: AND og.owner = c.owner

Line 4536: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og

4532: ,g_created_by
4533: ,g_last_updated_by
4534: ,g_last_update_date
4535: ,g_last_update_login
4536: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4537: WHERE c.table_name = e.object_name
4538: AND og.object_name = e.object_name
4539: AND og.owner = c.owner
4540: AND e.object_type_code IN ('HEADER','HEADER_MLS')

Line 4582: FROM dba_tab_columns c, xla_reference_objects r,

4578: ,g_created_by
4579: ,g_last_updated_by
4580: ,g_last_update_date
4581: ,g_last_update_login
4582: FROM dba_tab_columns c, xla_reference_objects r,
4583: xla_reference_objects_gt og, xla_extract_objects e
4584: WHERE c.table_name = r.reference_object_name
4585: AND og.reference_object_name = r.reference_object_name
4586: AND og.owner = c.owner

Line 4633: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og

4629: ,g_created_by
4630: ,g_last_updated_by
4631: ,g_last_update_date
4632: ,g_last_update_login
4633: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4634: WHERE c.table_name = e.object_name
4635: AND og.object_name = e.object_name
4636: AND og.owner = c.owner
4637: AND e.object_type_code IN ('LINE','LINE_MLS')

Line 4679: FROM dba_tab_columns c, xla_reference_objects r,

4675: ,g_created_by
4676: ,g_last_updated_by
4677: ,g_last_update_date
4678: ,g_last_update_login
4679: FROM dba_tab_columns c, xla_reference_objects r,
4680: xla_reference_objects_gt og, xla_extract_objects e
4681: WHERE c.table_name = r.reference_object_name
4682: AND og.reference_object_name = r.reference_object_name
4683: AND og.owner = c.owner

Line 4729: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og

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

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 4811: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo,

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

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 4901: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og

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

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 4983: FROM dba_tab_columns c, xla_reference_objects r,user_objects uo,

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'

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 5074: FROM dba_tab_columns c, user_objects uo,xla_extract_objects e, xla_extract_objects_gt og

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

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 5156: FROM dba_tab_columns c,user_objects uo, xla_reference_objects r,

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'

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 5248: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og

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

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 5330: FROM dba_tab_columns c,user_objects uo, xla_reference_objects r,

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'

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