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_EVENT_SOURCES

Line 710: FROM xla_event_sources e, xla_sources_b s

706: 'HEADER','L','LINE')),
707: 'Y',
708: decode(e.level_code,'H','HEADER_MLS','L','LINE_MLS'))
709: source_level_code
710: FROM xla_event_sources e, xla_sources_b s
711: WHERE e.source_application_id = s.application_id
712: AND e.source_code = s.source_code
713: AND e.source_type_code = s.source_type_code
714: AND e.application_id = p_application_id

Line 2448: FROM xla_event_sources e

2444: AND s.event_class_code = p_event_class_code
2445: AND s.source_application_id = p_application_id
2446: AND s.source_type_code = 'S'
2447: AND NOT EXISTS (SELECT 'x'
2448: FROM xla_event_sources e
2449: WHERE e.application_id = s.application_id
2450: AND e.event_class_code = s.event_class_code
2451: AND e.source_application_id = s.source_application_id
2452: AND e.source_type_code = s.source_type_code

Line 3377: INSERT INTO xla_event_sources

3373: -- available in an always populated extract object
3374:
3375: -- Assign sources at header level to the event class
3376: -- for header extract objects that are always populated
3377: INSERT INTO xla_event_sources
3378: (source_code
3379: ,application_id
3380: ,entity_code
3381: ,event_class_code

Line 3414: FROM xla_event_sources s

3410: AND e.entity_code = p_entity_code
3411: AND e.event_class_code = p_event_class_code
3412: AND e.always_populated_flag = 'Y'
3413: AND NOT EXISTS (SELECT 'x'
3414: FROM xla_event_sources s
3415: WHERE s.application_id = p_application_id
3416: AND s.entity_code = p_entity_code
3417: AND s.event_class_code = p_event_class_code
3418: AND s.source_application_id = p_application_id

Line 3423: INSERT INTO xla_event_sources

3419: AND s.source_code = c.column_name));
3420:
3421: -- Assign sources at header level to the event class
3422: -- for header reference objects that are always populated
3423: INSERT INTO xla_event_sources
3424: (source_code
3425: ,application_id
3426: ,entity_code
3427: ,event_class_code

Line 3465: FROM xla_event_sources s

3461: AND r.entity_code = p_entity_code
3462: AND r.event_class_code = p_event_class_code
3463: AND r.always_populated_flag = 'Y'
3464: AND NOT EXISTS (SELECT 'x'
3465: FROM xla_event_sources s
3466: WHERE s.application_id = p_application_id
3467: AND s.entity_code = p_entity_code
3468: AND s.event_class_code = p_event_class_code
3469: AND s.source_application_id = r.reference_object_appl_id

Line 3474: INSERT INTO xla_event_sources

3470: AND s.source_code = c.column_name));
3471:
3472: -- Assign sources at line level to the event class
3473: -- for line extract objects that are always populated
3474: INSERT INTO xla_event_sources
3475: (source_code
3476: ,application_id
3477: ,entity_code
3478: ,event_class_code

Line 3511: FROM xla_event_sources s

3507: AND e.entity_code = p_entity_code
3508: AND e.event_class_code = p_event_class_code
3509: AND e.always_populated_flag = 'Y'
3510: AND NOT EXISTS (SELECT 'x'
3511: FROM xla_event_sources s
3512: WHERE s.application_id = p_application_id
3513: AND s.entity_code = p_entity_code
3514: AND s.event_class_code = p_event_class_code
3515: AND s.source_application_id = p_application_id

Line 3520: INSERT INTO xla_event_sources

3516: AND s.source_code = c.column_name));
3517:
3518: -- Assign sources at line level to the event class
3519: -- for line reference objects that are always populated
3520: INSERT INTO xla_event_sources
3521: (source_code
3522: ,application_id
3523: ,entity_code
3524: ,event_class_code

Line 3562: FROM xla_event_sources s

3558: AND r.entity_code = p_entity_code
3559: AND r.event_class_code = p_event_class_code
3560: AND r.always_populated_flag = 'Y'
3561: AND NOT EXISTS (SELECT 'x'
3562: FROM xla_event_sources s
3563: WHERE s.application_id = p_application_id
3564: AND s.entity_code = p_entity_code
3565: AND s.event_class_code = p_event_class_code
3566: AND s.source_application_id = r.reference_object_appl_id

Line 3571: INSERT INTO xla_event_sources

3567: AND s.source_code = c.column_name));
3568:
3569: -- Assign sources at header level to the event class
3570: -- for header extract objects that are not always populated
3571: INSERT INTO xla_event_sources
3572: (source_code
3573: ,application_id
3574: ,entity_code
3575: ,event_class_code

Line 3608: FROM xla_event_sources s

3604: AND e.entity_code = p_entity_code
3605: AND e.event_class_code = p_event_class_code
3606: AND e.always_populated_flag = 'N'
3607: AND NOT EXISTS (SELECT 'x'
3608: FROM xla_event_sources s
3609: WHERE s.application_id = p_application_id
3610: AND s.entity_code = p_entity_code
3611: AND s.event_class_code = p_event_class_code
3612: AND s.source_application_id = p_application_id

Line 3617: INSERT INTO xla_event_sources

3613: AND s.source_code = c.column_name));
3614:
3615: -- Assign sources at header level to the event class
3616: -- for header reference objects that are not always populated
3617: INSERT INTO xla_event_sources
3618: (source_code
3619: ,application_id
3620: ,entity_code
3621: ,event_class_code

Line 3659: FROM xla_event_sources s

3655: AND r.entity_code = p_entity_code
3656: AND r.event_class_code = p_event_class_code
3657: AND r.always_populated_flag = 'N'
3658: AND NOT EXISTS (SELECT 'x'
3659: FROM xla_event_sources s
3660: WHERE s.application_id = p_application_id
3661: AND s.entity_code = p_entity_code
3662: AND s.event_class_code = p_event_class_code
3663: AND s.source_application_id = r.reference_object_appl_id

Line 3668: INSERT INTO xla_event_sources

3664: AND s.source_code = c.column_name));
3665:
3666: -- Assign sources at line level to the event class
3667: -- for line extract objects that are not always populated
3668: INSERT INTO xla_event_sources
3669: (source_code
3670: ,application_id
3671: ,entity_code
3672: ,event_class_code

Line 3705: FROM xla_event_sources s

3701: AND e.entity_code = p_entity_code
3702: AND e.event_class_code = p_event_class_code
3703: AND e.always_populated_flag = 'N'
3704: AND NOT EXISTS (SELECT 'x'
3705: FROM xla_event_sources s
3706: WHERE s.application_id = p_application_id
3707: AND s.entity_code = p_entity_code
3708: AND s.event_class_code = p_event_class_code
3709: AND s.source_application_id = p_application_id

Line 3714: INSERT INTO xla_event_sources

3710: AND s.source_code = c.column_name));
3711:
3712: -- Assign sources at line level to the event class
3713: -- for line extract objects that are not always populated
3714: INSERT INTO xla_event_sources
3715: (source_code
3716: ,application_id
3717: ,entity_code
3718: ,event_class_code

Line 3756: FROM xla_event_sources s

3752: AND r.entity_code = p_entity_code
3753: AND r.event_class_code = p_event_class_code
3754: AND r.always_populated_flag = 'N'
3755: AND NOT EXISTS (SELECT 'x'
3756: FROM xla_event_sources s
3757: WHERE s.application_id = p_application_id
3758: AND s.entity_code = p_entity_code
3759: AND s.event_class_code = p_event_class_code
3760: AND s.source_application_id = r.reference_object_appl_id