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 394: FROM xla_reference_objects_gt o

390: AND e.entity_code = r.entity_code
391: AND e.event_class_code = r.event_class_code
392: AND e.object_name = r.object_name
393: AND not exists (SELECT 'x'
394: FROM xla_reference_objects_gt o
395: WHERE o.reference_object_name = r.reference_object_name);
396:
397:
398: l_ec_objects c_ec_objects%rowtype;

Line 443: FROM xla_reference_objects_gt o

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

Line 871: xla_reference_objects_gt og

867: r.always_populated_flag extract_object_pop_flag,
868: g.source_datatype_code column_datatype_code,
869: r.join_condition, r.linked_to_ref_obj_name
870: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
871: xla_reference_objects_gt og
872: WHERE g.application_id = r.application_id
873: AND g.entity_code = r.entity_code
874: AND g.event_class_code = r.event_class_code
875: AND g.source_application_id = r.reference_object_appl_id

Line 938: xla_reference_objects_gt og

934: r.always_populated_flag extract_object_pop_flag,
935: g.source_datatype_code column_datatype_code,
936: r.join_condition, r.linked_to_ref_obj_name
937: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
938: xla_reference_objects_gt og
939: WHERE g.application_id = r.application_id
940: AND g.entity_code = r.entity_code
941: AND g.event_class_code = r.event_class_code
942: AND g.source_application_id = r.reference_object_appl_id

Line 1013: ,xla_reference_objects_gt og

1009: ,r.join_condition
1010: FROM xla_evt_class_sources_gt g
1011: ,xla_reference_objects r
1012: ,xla_extract_objects o
1013: ,xla_reference_objects_gt og
1014: WHERE g.application_id = r.application_id
1015: AND g.entity_code = r.entity_code
1016: AND g.event_class_code = r.event_class_code
1017: AND g.source_level_code = o.object_type_code

Line 1502: DELETE FROM xla_reference_objects_gt;

1498: l_product_rule_code := p_product_rule_code;
1499: l_product_rule_type_code := p_product_rule_type_code;
1500:
1501: DELETE FROM xla_extract_objects_gt;
1502: DELETE FROM xla_reference_objects_gt;
1503:
1504: -- Get owner for current schema
1505: SELECT user
1506: INTO l_user

Line 1529: INTO xla_reference_objects_gt

1525:
1526: -- Insert reference objects for an event class and current owner in GT table
1527: -- Assume duplicate objects are not used for an event class
1528: INSERT
1529: INTO xla_reference_objects_gt
1530: (reference_object_name
1531: ,owner)
1532: SELECT rfr.reference_object_name, l_user
1533: FROM xla_reference_objects rfr

Line 1569: INTO xla_reference_objects_gt

1565:
1566: -- Insert objects for an event class and different owner in GT table
1567: -- Assume duplicate objects are not used for an event class
1568: INSERT
1569: INTO xla_reference_objects_gt
1570: (reference_object_name
1571: ,owner)
1572: SELECT rfr.reference_object_name
1573: ,(SELECT syn.table_owner

Line 1635: INTO xla_reference_objects_gt

1631:
1632: ELSE
1633: BEGIN
1634: INSERT
1635: INTO xla_reference_objects_gt
1636: (reference_object_name
1637: ,owner)
1638: VALUES(l_object_name
1639: ,l_user);

Line 1689: INTO xla_reference_objects_gt

1685: END;
1686: ELSE
1687: BEGIN
1688: INSERT
1689: INTO xla_reference_objects_gt
1690: (reference_object_name
1691: ,owner)
1692: VALUES(l_object_name
1693: ,l_syn_owner);

Line 2917: xla_reference_objects_gt og, xla_extract_objects e

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
2921: AND r.application_id = p_application_id

Line 3451: xla_reference_objects_gt og, xla_extract_objects e

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
3455: AND e.application_id = p_application_id

Line 3548: xla_reference_objects_gt og, xla_extract_objects e

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
3552: AND e.application_id = p_application_id

Line 3645: xla_reference_objects_gt og, xla_extract_objects e

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
3649: AND e.application_id = p_application_id

Line 3742: xla_reference_objects_gt og, xla_extract_objects e

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
3746: AND e.application_id = p_application_id