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 XLA_REFERENCE_OBJECTS_GT

Line 398: FROM xla_reference_objects_gt o

394: AND e.entity_code = r.entity_code
395: AND e.event_class_code = r.event_class_code
396: AND e.object_name = r.object_name
397: AND not exists (SELECT 'x'
398: FROM xla_reference_objects_gt o
399: WHERE o.reference_object_name = r.reference_object_name);
400:
401:
402: l_ec_objects c_ec_objects%rowtype;

Line 447: FROM xla_reference_objects_gt o

443: AND e.application_id = r.application_id
444: AND e.entity_code = r.entity_code
445: AND e.event_class_code = r.event_class_code
446: AND not exists (SELECT 'x'
447: FROM xla_reference_objects_gt o
448: WHERE o.reference_object_name = r.reference_object_name);
449:
450: l_aad_objects c_aad_objects%rowtype;
451: l_message_name VARCHAR2(30);

Line 934: xla_reference_objects_gt og

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
938: AND g.source_application_id = r.reference_object_appl_id

Line 967: xla_reference_objects_gt og

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
971: AND g.source_application_id = r.reference_object_appl_id

Line 1117: xla_reference_objects_gt og

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
1121: AND g.source_application_id = r.reference_object_appl_id

Line 1149: xla_reference_objects_gt og

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
1153: AND g.source_application_id = r.reference_object_appl_id

Line 1321: ,xla_reference_objects_gt og

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
1325: AND g.source_level_code = o.object_type_code

Line 1368: ,xla_reference_objects_gt og

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
1372: AND g.source_level_code = o.object_type_code

Line 1881: DELETE FROM xla_reference_objects_gt;

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
1885: INTO l_user

Line 1908: INTO xla_reference_objects_gt

1904:
1905: -- Insert reference objects for an event class and current owner in GT table
1906: -- Assume duplicate objects are not used for an event class
1907: INSERT
1908: INTO xla_reference_objects_gt
1909: (reference_object_name
1910: ,owner)
1911: SELECT rfr.reference_object_name, l_user
1912: FROM xla_reference_objects rfr

Line 1948: INTO xla_reference_objects_gt

1944:
1945: -- Insert objects for an event class and different owner in GT table
1946: -- Assume duplicate objects are not used for an event class
1947: INSERT
1948: INTO xla_reference_objects_gt
1949: (reference_object_name
1950: ,owner)
1951: SELECT rfr.reference_object_name
1952: ,(SELECT syn.table_owner

Line 2014: INTO xla_reference_objects_gt

2010:
2011: ELSE
2012: BEGIN
2013: INSERT
2014: INTO xla_reference_objects_gt
2015: (reference_object_name
2016: ,owner)
2017: VALUES(l_object_name
2018: ,l_user);

Line 2068: INTO xla_reference_objects_gt

2064: END;
2065: ELSE
2066: BEGIN
2067: INSERT
2068: INTO xla_reference_objects_gt
2069: (reference_object_name
2070: ,owner)
2071: VALUES(l_object_name
2072: ,l_syn_owner);

Line 3672: xla_reference_objects_gt og, xla_extract_objects e

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

Line 3811: xla_reference_objects_gt og, xla_extract_objects e

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

Line 3850: xla_reference_objects_gt og, xla_extract_objects e

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

Line 4389: xla_reference_objects_gt og, xla_extract_objects e

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

Line 4486: xla_reference_objects_gt og, xla_extract_objects e

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

Line 4583: xla_reference_objects_gt og, xla_extract_objects e

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

Line 4680: xla_reference_objects_gt og, xla_extract_objects e

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

Line 4812: xla_reference_objects_gt og, xla_extract_objects e

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

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 4984: xla_reference_objects_gt og, xla_extract_objects e

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

Line 5021: xla_reference_objects_gt og, xla_extract_objects e

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'

Line 5157: xla_reference_objects_gt og, xla_extract_objects e

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

Line 5194: xla_reference_objects_gt og, xla_extract_objects e

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

Line 5331: xla_reference_objects_gt og, xla_extract_objects e

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

Line 5369: xla_reference_objects_gt og, xla_extract_objects e

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