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_00206_AAD_S_000004_PKG dependencies on ALL_OBJECTS

Line 2927: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

2923: END source_meaning
2924: FROM xla_events_gt xet
2925: , LNS_LOAN_HEADERS_EXT_V h1
2926: , fnd_lookup_values fvl1
2927: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
2928: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2929: AND xet.event_type_code = C_EVENT_TYPE_CODE
2930: AND h1.event_id = xet.event_id
2931: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 3905: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

3901: , LNS_LOAN_HEADERS_EXT_V h2
3902: , fnd_lookup_values fvl1
3903: , fnd_lookup_values fvl10
3904: , fnd_lookup_values fvl14
3905: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
3906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3907: AND xet.event_type_code = C_EVENT_TYPE_CODE
3908: AND h2.event_id = xet.event_id
3909: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 4065: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

4061: , fnd_lookup_values fvl4
4062: , fnd_lookup_values fvl6
4063: , fnd_lookup_values fvl8
4064: , fnd_lookup_values fvl12
4065: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4067: AND xet.event_type_code = C_EVENT_TYPE_CODE
4068: AND l1.event_id = xet.event_id
4069: AND fvl4.lookup_type(+) = 'LOAN_DISTRIBUTION_ACCOUNTS'

Line 5242: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

5238: , LNS_LOAN_HEADERS_EXT_V h2
5239: , fnd_lookup_values fvl1
5240: , fnd_lookup_values fvl10
5241: , fnd_lookup_values fvl14
5242: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5243: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5244: AND xet.event_class_code = C_EVENT_CLASS_CODE
5245: AND h2.event_id = xet.event_id
5246: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 5384: , (select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

5380: FROM xla_events_gt xet
5381: , LNS_LOAN_DETAILS_EXT_V l1
5382: , fnd_lookup_values fvl4
5383: , fnd_lookup_values fvl6
5384: , (select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
5385: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5386: AND xet.event_class_code = C_EVENT_CLASS_CODE
5387: AND l1.event_id = xet.event_id
5388: AND fvl4.lookup_type(+) = 'LOAN_DISTRIBUTION_ACCOUNTS'

Line 6485: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)

6481: END source_meaning
6482: FROM xla_events_gt xet
6483: , LNS_LOAN_HEADERS_EXT_V h1
6484: , fnd_lookup_values fvl1
6485: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
6486: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6487: AND xet.event_type_code = C_EVENT_TYPE_CODE
6488: AND h1.event_id = xet.event_id
6489: AND fvl1.lookup_type(+) = 'LOAN_CLASS'