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

Line 384: FROM xla_reference_objects r

380: UNION ALL
381: SELECT r.reference_object_name
382: ,e.object_type_code
383: ,C_REF_OBJECT_FLAG_Y ref_object_flag
384: FROM xla_reference_objects r
385: ,xla_extract_objects e
386: WHERE r.application_id = p_application_id
387: AND r.entity_code = p_entity_code
388: AND r.event_class_code = p_event_class_code

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 428: FROM xla_reference_objects r,

424: ,r.event_class_code
425: ,r.reference_object_name
426: ,e.object_type_code
427: ,C_REF_OBJECT_FLAG_Y ref_object_flag
428: FROM xla_reference_objects r,
429: xla_extract_objects e,
430: xla_prod_acct_headers h
431: WHERE h.application_id = p_application_id
432: AND h.amb_context_code = p_amb_context_code

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 870: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,

866: o.object_type_code extract_object_type,
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

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 937: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,

933: o.object_type_code extract_object_type,
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

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 1011: ,xla_reference_objects r

1007: AND r.reference_object_name = t.table_name
1008: AND t.column_name = g.source_code)
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

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 1435: FROM xla_reference_objects rfr, xla_prod_acct_headers hdr

1431: AND hdr.product_rule_type_code = p_product_rule_type_code
1432: AND hdr.product_rule_code = p_product_rule_code
1433: UNION ALL
1434: SELECT distinct rfr.reference_object_name, C_REF_OBJECT_FLAG_Y reference_object_flag
1435: FROM xla_reference_objects rfr, xla_prod_acct_headers hdr
1436: WHERE rfr.application_id = hdr.application_id
1437: AND rfr.entity_code = hdr.entity_code
1438: AND rfr.event_class_code = hdr.event_class_code
1439: AND hdr.application_id = p_application_id

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 1533: FROM xla_reference_objects rfr

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
1534: WHERE
1535: EXISTS (SELECT /*+ no_unnest */ 'c'
1536: FROM user_objects usr
1537: WHERE rfr.reference_object_name = usr.object_name

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 1580: FROM xla_reference_objects rfr

1576: -- change rfr.object_name to rfr.reference_object_name, as told by dimple
1577: WHERE rfr.reference_object_name = usr.object_name
1578: AND usr.object_name = syn.synonym_name
1579: AND usr.object_type = 'SYNONYM')
1580: FROM xla_reference_objects rfr
1581: WHERE EXISTS (SELECT /*+ no_unnest */ 'c'
1582: FROM user_objects usr
1583: ,user_synonyms syn
1584: -- change rfr.object_name to rfr.reference_object_name, as told by dimple

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 2916: FROM dba_tab_columns c, xla_reference_objects r,

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

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 2959: FROM xla_sources_b e, xla_reference_objects r

2955:
2956: CURSOR c_ref_tl_sources
2957: IS
2958: SELECT distinct reference_object_appl_id, source_code
2959: FROM xla_sources_b e, xla_reference_objects r
2960: WHERE e.application_id = r.reference_object_appl_id
2961: AND r.application_id = p_application_id
2962: AND NOT EXISTS (SELECT 'x'
2963: FROM xla_sources_vl s

Line 3450: FROM dba_tab_columns c, xla_reference_objects r,

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

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 3547: FROM dba_tab_columns c, xla_reference_objects r,

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

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 3644: FROM dba_tab_columns c, xla_reference_objects r,

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

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 3741: FROM dba_tab_columns c, xla_reference_objects r,

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

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