[Home] [Help]
338:
339: CURSOR c_ec_obj_exist
340: IS
341: SELECT 'x'
342: FROM xla_extract_objects e
343: WHERE application_id = p_application_id
344: AND entity_code = p_entity_code
345: AND event_class_code = p_event_class_code;
346:
355: AND h.product_rule_type_code = p_product_rule_type_code
356: AND h.product_rule_code = p_product_rule_code
357: AND h.accounting_required_flag = 'Y'
358: AND NOT EXISTS (SELECT 'x'
359: FROM xla_extract_objects e
360: WHERE e.application_id = h.application_id
361: AND e.entity_code = h.entity_code
362: AND e.event_class_code = h.event_class_code);
363:
370: IS
371: SELECT object_name
372: ,object_type_code
373: ,C_REF_OBJECT_FLAG_N ref_object_flag
374: FROM xla_extract_objects e
375: WHERE application_id = p_application_id
376: AND entity_code = p_entity_code
377: AND event_class_code = p_event_class_code
378: AND not exists (SELECT 'x'
375: WHERE application_id = p_application_id
376: AND entity_code = p_entity_code
377: AND event_class_code = p_event_class_code
378: AND not exists (SELECT 'x'
379: FROM xla_extract_objects_gt o
380: WHERE o.object_name = e.object_name)
381: --
382: -- Get all reference objects for the event class that are not defined in the
383: -- database
385: SELECT r.reference_object_name
386: ,e.object_type_code
387: ,C_REF_OBJECT_FLAG_Y ref_object_flag
388: FROM xla_reference_objects r
389: ,xla_extract_objects e
390: WHERE r.application_id = p_application_id
391: AND r.entity_code = p_entity_code
392: AND r.event_class_code = p_event_class_code
393: AND e.application_id = r.application_id
410: ,e.event_class_code
411: ,e.object_name
412: ,e.object_type_code
413: ,C_REF_OBJECT_FLAG_N ref_object_flag
414: FROM xla_extract_objects e, xla_prod_acct_headers h
415: WHERE h.application_id = p_application_id
416: AND h.amb_context_code = p_amb_context_code
417: AND h.product_rule_type_code = p_product_rule_type_code
418: AND h.product_rule_code = p_product_rule_code
420: AND e.application_id = h.application_id
421: AND e.entity_code = h.entity_code
422: AND e.event_class_code = h.event_class_code
423: AND not exists (SELECT 'x'
424: FROM xla_extract_objects_gt o
425: WHERE o.object_name = e.object_name)
426: UNION ALL
427: SELECT r.entity_code
428: ,r.event_class_code
429: ,r.reference_object_name
430: ,e.object_type_code
431: ,C_REF_OBJECT_FLAG_Y ref_object_flag
432: FROM xla_reference_objects r,
433: xla_extract_objects e,
434: xla_prod_acct_headers h
435: WHERE h.application_id = p_application_id
436: AND h.amb_context_code = p_amb_context_code
437: AND h.product_rule_type_code = p_product_rule_type_code
839: o.object_name extract_object_name,
840: o.object_type_code extract_object_type,
841: o.always_populated_flag extract_object_pop_flag,
842: g.source_datatype_code column_datatype_code
843: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
844: xla_extract_objects_gt og
845: WHERE g.application_id = o.application_id
846: AND g.entity_code = o.entity_code
847: AND g.event_class_code = o.event_class_code
840: o.object_type_code extract_object_type,
841: o.always_populated_flag extract_object_pop_flag,
842: g.source_datatype_code column_datatype_code
843: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
844: xla_extract_objects_gt og
845: WHERE g.application_id = o.application_id
846: AND g.entity_code = o.entity_code
847: AND g.event_class_code = o.event_class_code
848: AND g.source_level_code = o.object_type_code
868: o.object_name extract_object_name,
869: o.object_type_code extract_object_type,
870: o.always_populated_flag extract_object_pop_flag,
871: g.source_datatype_code column_datatype_code
872: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
873: xla_extract_objects_gt og
874: WHERE g.application_id = o.application_id
875: AND g.entity_code = o.entity_code
876: AND g.event_class_code = o.event_class_code
869: o.object_type_code extract_object_type,
870: o.always_populated_flag extract_object_pop_flag,
871: g.source_datatype_code column_datatype_code
872: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
873: xla_extract_objects_gt og
874: WHERE g.application_id = o.application_id
875: AND g.entity_code = o.entity_code
876: AND g.event_class_code = o.event_class_code
877: AND g.source_level_code = o.object_type_code
929: o.object_type_code extract_object_type,
930: r.always_populated_flag extract_object_pop_flag,
931: g.source_datatype_code column_datatype_code,
932: r.join_condition, r.linked_to_ref_obj_name
933: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
934: xla_reference_objects_gt og
935: WHERE g.application_id = r.application_id
936: AND g.entity_code = r.entity_code
937: AND g.event_class_code = r.event_class_code
962: o.object_type_code extract_object_type,
963: r.always_populated_flag extract_object_pop_flag,
964: g.source_datatype_code column_datatype_code,
965: r.join_condition, r.linked_to_ref_obj_name
966: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
967: xla_reference_objects_gt og
968: WHERE g.application_id = r.application_id
969: AND g.entity_code = r.entity_code
970: AND g.event_class_code = r.event_class_code
1026: o.object_name extract_object_name,
1027: o.object_type_code extract_object_type,
1028: o.always_populated_flag extract_object_pop_flag,
1029: g.source_datatype_code column_datatype_code
1030: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1031: xla_extract_objects_gt og
1032: WHERE g.application_id = o.application_id
1033: AND g.entity_code = o.entity_code
1034: AND g.event_class_code = o.event_class_code
1027: o.object_type_code extract_object_type,
1028: o.always_populated_flag extract_object_pop_flag,
1029: g.source_datatype_code column_datatype_code
1030: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1031: xla_extract_objects_gt og
1032: WHERE g.application_id = o.application_id
1033: AND g.entity_code = o.entity_code
1034: AND g.event_class_code = o.event_class_code
1035: AND g.source_level_code = o.object_type_code
1053: o.object_name extract_object_name,
1054: o.object_type_code extract_object_type,
1055: o.always_populated_flag extract_object_pop_flag,
1056: g.source_datatype_code column_datatype_code
1057: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1058: xla_extract_objects_gt og
1059: WHERE g.application_id = o.application_id
1060: AND g.entity_code = o.entity_code
1061: AND g.event_class_code = o.event_class_code
1054: o.object_type_code extract_object_type,
1055: o.always_populated_flag extract_object_pop_flag,
1056: g.source_datatype_code column_datatype_code
1057: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1058: xla_extract_objects_gt og
1059: WHERE g.application_id = o.application_id
1060: AND g.entity_code = o.entity_code
1061: AND g.event_class_code = o.event_class_code
1062: AND g.source_level_code = o.object_type_code
1112: o.object_type_code extract_object_type,
1113: r.always_populated_flag extract_object_pop_flag,
1114: g.source_datatype_code column_datatype_code,
1115: r.join_condition, r.linked_to_ref_obj_name
1116: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
1117: xla_reference_objects_gt og
1118: WHERE g.application_id = r.application_id
1119: AND g.entity_code = r.entity_code
1120: AND g.event_class_code = r.event_class_code
1144: o.object_type_code extract_object_type,
1145: r.always_populated_flag extract_object_pop_flag,
1146: g.source_datatype_code column_datatype_code,
1147: r.join_condition, r.linked_to_ref_obj_name
1148: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
1149: xla_reference_objects_gt og
1150: WHERE g.application_id = r.application_id
1151: AND g.entity_code = r.entity_code
1152: AND g.event_class_code = r.event_class_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,
1217: xla_extract_objects_gt og
1218: WHERE g.application_id = o.application_id
1219: AND g.entity_code = o.entity_code
1220: AND g.event_class_code = o.event_class_code
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,
1217: xla_extract_objects_gt og
1218: WHERE g.application_id = o.application_id
1219: AND g.entity_code = o.entity_code
1220: AND g.event_class_code = o.event_class_code
1221: AND g.source_level_code = o.object_type_code
1255: AND uo.object_name = o.object_name
1256: AND uo.object_type = 'SYNONYM'
1257: AND t.column_name = g.source_code
1258: )
1259: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1260: xla_extract_objects_gt og
1261: WHERE g.application_id = o.application_id
1262: AND g.entity_code = o.entity_code
1263: AND g.event_class_code = o.event_class_code
1256: AND uo.object_type = 'SYNONYM'
1257: AND t.column_name = g.source_code
1258: )
1259: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1260: xla_extract_objects_gt og
1261: WHERE g.application_id = o.application_id
1262: AND g.entity_code = o.entity_code
1263: AND g.event_class_code = o.event_class_code
1264: AND g.source_level_code = o.object_type_code
1316: AND t.column_name = g.source_code)
1317: ,r.join_condition
1318: FROM xla_evt_class_sources_gt g
1319: ,xla_reference_objects r
1320: ,xla_extract_objects o
1321: ,xla_reference_objects_gt og
1322: WHERE g.application_id = r.application_id
1323: AND g.entity_code = r.entity_code
1324: AND g.event_class_code = r.event_class_code
1363: AND t.column_name = g.source_code)
1364: ,r.join_condition
1365: FROM xla_evt_class_sources_gt g
1366: ,xla_reference_objects r
1367: ,xla_extract_objects o
1368: ,xla_reference_objects_gt og
1369: WHERE g.application_id = r.application_id
1370: AND g.entity_code = r.entity_code
1371: AND g.event_class_code = r.event_class_code
1800:
1801: CURSOR c_aad_objects
1802: IS
1803: SELECT distinct ext.object_name, C_REF_OBJECT_FLAG_N reference_object_flag
1804: FROM xla_extract_objects ext, xla_prod_acct_headers hdr
1805: WHERE ext.application_id = hdr.application_id
1806: AND ext.entity_code = hdr.entity_code
1807: AND ext.event_class_code = hdr.event_class_code
1808: AND hdr.application_id = p_application_id
1876: l_amb_context_code := p_amb_context_code;
1877: l_product_rule_code := p_product_rule_code;
1878: l_product_rule_type_code := p_product_rule_type_code;
1879:
1880: DELETE FROM xla_extract_objects_gt;
1881: DELETE FROM xla_reference_objects_gt;
1882:
1883: -- Get owner for current schema
1884: SELECT user
1888: IF p_product_rule_code is NULL THEN
1889:
1890: -- Insert objects for an event class and current owner in GT table
1891: INSERT
1892: INTO xla_extract_objects_gt
1893: (object_name
1894: ,owner)
1895: SELECT ext.object_name, l_user
1896: FROM xla_extract_objects ext
1892: INTO xla_extract_objects_gt
1893: (object_name
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' )
1920: AND rfr.event_class_code = p_event_class_code;
1921:
1922: -- Insert objects for an event class and different owner in GT table
1923: INSERT
1924: INTO xla_extract_objects_gt
1925: (object_name
1926: ,owner)
1927: SELECT ext.object_name
1928: ,(SELECT syn.table_owner
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
1935: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1936: FROM user_objects usr
1937: ,user_synonyms syn
1938: WHERE ext.object_name = usr.object_name
1985: IF l_ref_object_flag = 'N' THEN
1986:
1987: BEGIN
1988: INSERT
1989: INTO xla_extract_objects_gt
1990: (object_name
1991: ,owner)
1992: VALUES(l_object_name
1993: ,l_user);
2040:
2041: IF l_ref_object_flag = 'N' THEN
2042: BEGIN
2043: INSERT
2044: INTO xla_extract_objects_gt
2045: (object_name
2046: ,owner)
2047: VALUES(l_object_name
2048: ,l_syn_owner);
2160: /*
2161: CURSOR c_aad_event_id
2162: IS
2163: SELECT distinct extract_object_name, extract_object_type_code
2164: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2165: WHERE application_id = p_application_id
2166: AND entity_code = p_entity_code
2167: AND event_class_code = p_event_class_code
2168: AND extract_object_name IS NOT NULL
2177: */
2178: CURSOR c_aad_event_id
2179: IS
2180: SELECT distinct extract_object_name, extract_object_type_code
2181: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2182: WHERE application_id = p_application_id
2183: AND entity_code = p_entity_code
2184: AND event_class_code = p_event_class_code
2185: AND extract_object_name IS NOT NULL
2226: /*
2227: CURSOR c_aad_language
2228: IS
2229: SELECT distinct extract_object_name, extract_object_type_code
2230: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2231: WHERE application_id = p_application_id
2232: AND entity_code = p_entity_code
2233: AND event_class_code = p_event_class_code
2234: AND extract_object_name IS NOT NULL
2243: -- 4420371 AND t.NULLABLE = 'N'); */
2244: CURSOR c_aad_language
2245: IS
2246: SELECT distinct extract_object_name, extract_object_type_code
2247: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2248: WHERE application_id = p_application_id
2249: AND entity_code = p_entity_code
2250: AND event_class_code = p_event_class_code
2251: AND extract_object_name IS NOT NULL
2294: /*
2295: CURSOR c_aad_line_number
2296: IS
2297: SELECT distinct extract_object_name, extract_object_type_code
2298: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2299: WHERE application_id = p_application_id
2300: AND entity_code = p_entity_code
2301: AND event_class_code = p_event_class_code
2302: AND extract_object_name IS NOT NULL
2311: -- 4420371 AND t.NULLABLE = 'N'); */
2312: CURSOR c_aad_line_number
2313: IS
2314: SELECT distinct extract_object_name, extract_object_type_code
2315: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2316: WHERE application_id = p_application_id
2317: AND entity_code = p_entity_code
2318: AND event_class_code = p_event_class_code
2319: AND extract_object_name IS NOT NULL
2361: /*
2362: CURSOR c_aad_ledger_id
2363: IS
2364: SELECT distinct extract_object_name, extract_object_type_code
2365: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
2366: WHERE e.application_id = p_application_id
2367: AND e.entity_code = p_entity_code
2368: AND e.event_class_code = p_event_class_code
2369: AND e.extract_object_name IS NOT NULL
2379: AND t.data_type = 'NUMBER'); */
2380: CURSOR c_aad_ledger_id
2381: IS
2382: SELECT distinct extract_object_name, extract_object_type_code
2383: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
2384: WHERE e.application_id = p_application_id
2385: AND e.entity_code = p_entity_code
2386: AND e.event_class_code = p_event_class_code
2387: AND e.extract_object_name IS NOT NULL
2430: /*
2431: CURSOR c_event_id
2432: IS
2433: SELECT e.object_name, object_type_code
2434: FROM xla_extract_objects e, xla_extract_objects_gt og
2435: WHERE application_id = p_application_id
2436: AND entity_code = p_entity_code
2437: AND event_class_code = p_event_class_code
2438: AND e.object_name = og.object_name
2443: AND t.column_name = 'EVENT_ID'
2444: AND t.data_type = 'NUMBER')
2445: -- 4420371 AND t.nullable = 'N')
2446: AND EXISTS (SELECT 'y'
2447: FROM xla_extract_objects_gt a
2448: WHERE a.object_name = e.object_name); */
2449: CURSOR c_event_id
2450: IS
2451: SELECT e.object_name, object_type_code
2448: WHERE a.object_name = e.object_name); */
2449: CURSOR c_event_id
2450: IS
2451: SELECT e.object_name, object_type_code
2452: FROM xla_extract_objects e, xla_extract_objects_gt og
2453: WHERE application_id = p_application_id
2454: AND entity_code = p_entity_code
2455: AND event_class_code = p_event_class_code
2456: AND e.object_name = og.object_name
2487: )
2488: )
2489: -- 4420371 AND t.nullable = 'N')
2490: AND EXISTS (SELECT 'y'
2491: FROM xla_extract_objects_gt a
2492: WHERE a.object_name = e.object_name);
2493:
2494:
2495: l_event_id c_event_id%rowtype;
2499: /*
2500: CURSOR c_language
2501: IS
2502: SELECT e.object_name, object_type_code
2503: FROM xla_extract_objects e, xla_extract_objects_gt og
2504: WHERE application_id = p_application_id
2505: AND entity_code = p_entity_code
2506: AND event_class_code = p_event_class_code
2507: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
2513: AND t.column_name = 'LANGUAGE'
2514: AND t.data_type = 'VARCHAR2')
2515: -- 4420371 AND t.nullable = 'N')
2516: AND EXISTS (SELECT 'y'
2517: FROM xla_extract_objects_gt a
2518: WHERE a.object_name = e.object_name); */
2519: CURSOR c_language
2520: IS
2521: SELECT e.object_name, object_type_code
2518: WHERE a.object_name = e.object_name); */
2519: CURSOR c_language
2520: IS
2521: SELECT e.object_name, object_type_code
2522: FROM xla_extract_objects e, xla_extract_objects_gt og
2523: WHERE application_id = p_application_id
2524: AND entity_code = p_entity_code
2525: AND event_class_code = p_event_class_code
2526: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
2558: )
2559: )
2560: -- 4420371 AND t.nullable = 'N')
2561: AND EXISTS (SELECT 'y'
2562: FROM xla_extract_objects_gt a
2563: WHERE a.object_name = e.object_name);
2564:
2565:
2566: l_language c_language%rowtype;
2570: /*
2571: CURSOR c_line_number
2572: IS
2573: SELECT e.object_name, object_type_code
2574: FROM xla_extract_objects e, xla_extract_objects_gt og
2575: WHERE application_id = p_application_id
2576: AND entity_code = p_entity_code
2577: AND event_class_code = p_event_class_code
2578: AND object_type_code IN ('LINE','LINE_MLS')
2584: AND t.column_name = 'LINE_NUMBER'
2585: AND t.data_type = 'NUMBER')
2586: -- 4420371 AND t.nullable = 'N')
2587: AND EXISTS (SELECT 'y'
2588: FROM xla_extract_objects_gt a
2589: WHERE a.object_name = e.object_name); */
2590: CURSOR c_line_number
2591: IS
2592: SELECT e.object_name, object_type_code
2589: WHERE a.object_name = e.object_name); */
2590: CURSOR c_line_number
2591: IS
2592: SELECT e.object_name, object_type_code
2593: FROM xla_extract_objects e, xla_extract_objects_gt og
2594: WHERE application_id = p_application_id
2595: AND entity_code = p_entity_code
2596: AND event_class_code = p_event_class_code
2597: AND object_type_code IN ('LINE','LINE_MLS')
2629: )
2630: )
2631: -- 4420371 AND t.nullable = 'N')
2632: AND EXISTS (SELECT 'y'
2633: FROM xla_extract_objects_gt a
2634: WHERE a.object_name = e.object_name);
2635:
2636:
2637: l_line_number c_line_number%rowtype;
2640: -- Added and commented for bug 15938563
2641: /* CURSOR c_ledger_id
2642: IS
2643: SELECT e.object_name, object_type_code
2644: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app
2645: WHERE e.application_id = p_application_id
2646: AND e.entity_code = p_entity_code
2647: AND e.event_class_code = p_event_class_code
2648: AND e.object_type_code IN ('LINE','LINE_MLS')
2655: AND og.owner = t.owner
2656: AND t.column_name = 'LEDGER_ID'
2657: AND t.data_type = 'NUMBER')
2658: AND EXISTS (SELECT 'y'
2659: FROM xla_extract_objects_gt a
2660: WHERE a.object_name = e.object_name); */
2661: CURSOR c_ledger_id
2662: IS
2663: SELECT e.object_name, object_type_code
2660: WHERE a.object_name = e.object_name); */
2661: CURSOR c_ledger_id
2662: IS
2663: SELECT e.object_name, object_type_code
2664: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app
2665: WHERE e.application_id = p_application_id
2666: AND e.entity_code = p_entity_code
2667: AND e.event_class_code = p_event_class_code
2668: AND e.object_type_code IN ('LINE','LINE_MLS')
2700: AND T.COLUMN_NAME = 'LEDGER_ID'
2701: and t.data_type = 'NUMBER'
2702: ))
2703: AND EXISTS (SELECT 'y'
2704: FROM xla_extract_objects_gt a
2705: WHERE a.object_name = e.object_name);
2706:
2707:
2708: l_ledger_id c_ledger_id%rowtype;
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
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: --
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
3676: AND r.application_id = p_application_id
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
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'
3815: AND r.reference_object_name = og.reference_object_name
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
3854: AND uo.object_name = r.reference_object_name
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')
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
4393: AND e.application_id = p_application_id
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')
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
4490: AND e.application_id = p_application_id
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')
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
4587: AND e.application_id = p_application_id
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')
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
4684: AND e.application_id = p_application_id
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
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
4816: AND uo.object_name = r.reference_object_name
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
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'
4988: AND og.reference_object_name = r.reference_object_name
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
5025: AND uo.object_type = 'SYNONYM'
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
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'
5161: AND og.reference_object_name = r.reference_object_name
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
5198: AND uo.object_name = r.reference_object_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
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'
5335: AND og.reference_object_name = r.reference_object_name
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
5373: AND uo.object_name = r.reference_object_name