[Home] [Help]
844: AND g.source_application_id = o.application_id
845: AND og.object_name = o.object_name
846: AND EXISTS (
847: SELECT 1
848: FROM dba_tab_columns t
849: WHERE og.owner = t.owner
850: AND o.object_name = t.table_name
851: AND t.column_name = g.source_code
852: AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = G.SOURCE_DATATYPE_CODE
880: AND r.object_name = o.object_name
881: AND og.reference_object_name = r.reference_object_name
882: AND EXISTS (
883: SELECT 1
884: FROM dba_tab_columns t
885: WHERE og.owner = t.owner
886: AND r.reference_object_name = t.table_name
887: AND t.column_name = g.source_code
888: AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code
912: AND g.source_application_id = o.application_id
913: AND og.object_name = o.object_name
914: AND EXISTS (
915: SELECT 1
916: FROM dba_tab_columns t
917: WHERE og.owner = t.owner
918: AND o.object_name = t.table_name
919: AND t.column_name = g.source_code
920: AND DECODE(T.DATA_TYPE,'CHAR','VARCHAR2',T.DATA_TYPE) = g.source_datatype_code
947: AND r.object_name = o.object_name
948: AND og.reference_object_name = r.reference_object_name
949: AND EXISTS (
950: SELECT 1
951: FROM dba_tab_columns t
952: WHERE og.owner = t.owner
953: AND r.reference_object_name = t.table_name
954: AND t.column_name = g.source_code
955: AND DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) = g.source_datatype_code
969: o.object_type_code extract_object_type,
970: o.always_populated_flag extract_object_pop_flag,
971: -- 4713242 Performance Fix
972: (SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
973: FROM dba_tab_columns T
974: WHERE og.owner = t.owner
975: AND o.object_name = t.table_name
976: AND t.column_name = g.source_code)
977: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
986: AND g.entity_code = p_entity_code
987: AND g.event_class_code = p_event_class_code
988: AND g.extract_object_name IS NULL
989: AND EXISTS (SELECT 1
990: FROM dba_tab_columns t
991: WHERE og.owner = t.owner
992: AND o.object_name = t.table_name
993: AND t.column_name = g.source_code);
994:
1001: ,o.object_type_code extract_object_type
1002: ,o.always_populated_flag extract_object_pop_flag
1003: -- 4713242 Performance Fix
1004: ,(SELECT DECODE(t.data_type,'CHAR','VARCHAR2',t.data_type) COLUMN_DATATYPE_CODE
1005: FROM dba_tab_columns T
1006: WHERE og.owner = t.owner
1007: AND r.reference_object_name = t.table_name
1008: AND t.column_name = g.source_code)
1009: ,r.join_condition
1024: AND g.entity_code = p_entity_code
1025: AND g.event_class_code = p_event_class_code
1026: AND g.extract_object_name IS NULL
1027: AND EXISTS (SELECT 1
1028: FROM dba_tab_columns t
1029: WHERE og.owner = t.owner
1030: AND r.reference_object_name = t.table_name
1031: AND t.column_name = g.source_code);
1032:
1786: AND event_class_code = p_event_class_code
1787: AND extract_object_name IS NOT NULL
1788: AND extract_object_name = og.object_name
1789: AND NOT EXISTS (SELECT 'x'
1790: FROM dba_tab_columns t
1791: WHERE t.table_name = og.object_name
1792: AND og.owner = t.owner
1793: AND t.column_name = 'EVENT_ID'
1794: AND t.data_type = 'NUMBER');
1807: AND extract_object_name IS NOT NULL
1808: AND extract_object_type_code IN ('HEADER_MLS','LINE_MLS')
1809: AND extract_object_name = og.object_name
1810: AND NOT EXISTS (SELECT 'x'
1811: FROM dba_tab_columns t
1812: WHERE t.table_name = og.object_name
1813: AND og.owner = t.owner
1814: AND t.column_name = 'LANGUAGE'
1815: AND t.data_type = 'VARCHAR2');
1828: AND extract_object_name IS NOT NULL
1829: AND extract_object_type_code IN ('LINE','LINE_MLS')
1830: AND extract_object_name = og.object_name
1831: AND NOT EXISTS (SELECT 'x'
1832: FROM dba_tab_columns t
1833: WHERE t.table_name = og.object_name
1834: AND og.owner = t.owner
1835: AND t.column_name = 'LINE_NUMBER'
1836: AND t.data_type = 'NUMBER');
1851: AND e.extract_object_name = og.object_name
1852: AND e.application_id = app.application_id
1853: AND app.alc_enabled_flag = 'N'
1854: AND NOT EXISTS (SELECT 'x'
1855: FROM dba_tab_columns t
1856: WHERE t.table_name = og.object_name
1857: AND og.owner = t.owner
1858: AND t.column_name = 'LEDGER_ID'
1859: AND t.data_type = 'NUMBER');
1869: AND entity_code = p_entity_code
1870: AND event_class_code = p_event_class_code
1871: AND e.object_name = og.object_name
1872: AND NOT EXISTS (SELECT 'x'
1873: FROM dba_tab_columns t
1874: WHERE t.table_name = og.object_name
1875: AND og.owner = t.owner
1876: AND t.column_name = 'EVENT_ID'
1877: AND t.data_type = 'NUMBER')
1892: AND event_class_code = p_event_class_code
1893: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
1894: AND e.object_name = og.object_name
1895: AND NOT EXISTS (SELECT 'x'
1896: FROM dba_tab_columns t
1897: WHERE t.table_name = og.object_name
1898: AND og.owner = t.owner
1899: AND t.column_name = 'LANGUAGE'
1900: AND t.data_type = 'VARCHAR2')
1915: AND event_class_code = p_event_class_code
1916: AND object_type_code IN ('LINE','LINE_MLS')
1917: AND e.object_name = og.object_name
1918: AND NOT EXISTS (SELECT 'x'
1919: FROM dba_tab_columns t
1920: WHERE t.table_name = og.object_name
1921: AND og.owner = t.owner
1922: AND t.column_name = 'LINE_NUMBER'
1923: AND t.data_type = 'NUMBER')
1940: AND e.object_name = og.object_name
1941: AND e.application_id = app.application_id
1942: AND app.alc_enabled_flag = 'N'
1943: AND NOT EXISTS (SELECT 'x'
1944: FROM dba_tab_columns t
1945: WHERE t.table_name = og.object_name
1946: AND og.owner = t.owner
1947: AND t.column_name = 'LEDGER_ID'
1948: AND t.data_type = 'NUMBER')
2856:
2857: CURSOR c_mls
2858: IS
2859: SELECT distinct c.column_name
2860: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
2861: WHERE c.table_name = e.object_name
2862: AND e.object_name = og.object_name
2863: AND og.owner = c.owner
2864: AND e.application_id = p_application_id
2878: WHEN 'HEADER' THEN 'N'
2879: WHEN 'LINE' THEN 'N'
2880: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
2881: END translated_flag
2882: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
2883: WHERE c.table_name = e.object_name
2884: AND e.object_name = og.object_name
2885: AND og.owner = c.owner
2886: --
2912: WHEN 'HEADER' THEN 'N'
2913: WHEN 'LINE' THEN 'N'
2914: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
2915: END translated_flag
2916: FROM dba_tab_columns c, xla_reference_objects r,
2917: xla_reference_objects_gt og, xla_extract_objects e
2918: WHERE c.table_name = r.reference_object_name
2919: AND r.reference_object_name = og.reference_object_name
2920: AND og.owner = c.owner
3400: ,g_created_by
3401: ,g_last_updated_by
3402: ,g_last_update_date
3403: ,g_last_update_login
3404: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3405: WHERE c.table_name = e.object_name
3406: AND og.object_name = e.object_name
3407: AND og.owner = c.owner
3408: AND e.object_type_code IN ('HEADER','HEADER_MLS')
3446: ,g_created_by
3447: ,g_last_updated_by
3448: ,g_last_update_date
3449: ,g_last_update_login
3450: FROM dba_tab_columns c, xla_reference_objects r,
3451: xla_reference_objects_gt og, xla_extract_objects e
3452: WHERE c.table_name = r.reference_object_name
3453: AND og.reference_object_name = r.reference_object_name
3454: AND og.owner = c.owner
3497: ,g_created_by
3498: ,g_last_updated_by
3499: ,g_last_update_date
3500: ,g_last_update_login
3501: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3502: WHERE c.table_name = e.object_name
3503: AND og.object_name = e.object_name
3504: AND og.owner = c.owner
3505: AND e.object_type_code IN ('LINE','LINE_MLS')
3543: ,g_created_by
3544: ,g_last_updated_by
3545: ,g_last_update_date
3546: ,g_last_update_login
3547: FROM dba_tab_columns c, xla_reference_objects r,
3548: xla_reference_objects_gt og, xla_extract_objects e
3549: WHERE c.table_name = r.reference_object_name
3550: AND og.reference_object_name = r.reference_object_name
3551: AND og.owner = c.owner
3594: ,g_created_by
3595: ,g_last_updated_by
3596: ,g_last_update_date
3597: ,g_last_update_login
3598: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3599: WHERE c.table_name = e.object_name
3600: AND og.object_name = e.object_name
3601: AND og.owner = c.owner
3602: AND e.object_type_code IN ('HEADER','HEADER_MLS')
3640: ,g_created_by
3641: ,g_last_updated_by
3642: ,g_last_update_date
3643: ,g_last_update_login
3644: FROM dba_tab_columns c, xla_reference_objects r,
3645: xla_reference_objects_gt og, xla_extract_objects e
3646: WHERE c.table_name = r.reference_object_name
3647: AND og.reference_object_name = r.reference_object_name
3648: AND og.owner = c.owner
3691: ,g_created_by
3692: ,g_last_updated_by
3693: ,g_last_update_date
3694: ,g_last_update_login
3695: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3696: WHERE c.table_name = e.object_name
3697: AND og.object_name = e.object_name
3698: AND og.owner = c.owner
3699: AND e.object_type_code IN ('LINE','LINE_MLS')
3737: ,g_created_by
3738: ,g_last_updated_by
3739: ,g_last_update_date
3740: ,g_last_update_login
3741: FROM dba_tab_columns c, xla_reference_objects r,
3742: xla_reference_objects_gt og, xla_extract_objects e
3743: WHERE c.table_name = r.reference_object_name
3744: AND og.reference_object_name = r.reference_object_name
3745: AND og.owner = c.owner