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

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

2952: , LNS_LOAN_HEADERS_EXT_V h2
2953: , fnd_lookup_values fvl1
2954: , fnd_lookup_values fvl10
2955: , fnd_lookup_values fvl14
2956: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
2957: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2958: AND xet.event_class_code = C_EVENT_CLASS_CODE
2959: AND h2.event_id = xet.event_id
2960: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

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

3113: , fnd_lookup_values fvl4
3114: , fnd_lookup_values fvl6
3115: , fnd_lookup_values fvl8
3116: , fnd_lookup_values fvl12
3117: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
3118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3119: AND xet.event_class_code = C_EVENT_CLASS_CODE
3120: AND l1.event_id = xet.event_id
3121: AND fvl4.lookup_type(+) = 'LOAN_DISTRIBUTION_ACCOUNTS'

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

4289: , LNS_LOAN_HEADERS_EXT_V h2
4290: , fnd_lookup_values fvl1
4291: , fnd_lookup_values fvl10
4292: , fnd_lookup_values fvl14
4293: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4295: AND xet.event_class_code = C_EVENT_CLASS_CODE
4296: AND h2.event_id = xet.event_id
4297: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

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

4431: FROM xla_events_gt xet
4432: , LNS_LOAN_DETAILS_EXT_V l1
4433: , fnd_lookup_values fvl4
4434: , fnd_lookup_values fvl6
4435: , (select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
4436: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4437: AND xet.event_class_code = C_EVENT_CLASS_CODE
4438: AND l1.event_id = xet.event_id
4439: AND fvl4.lookup_type(+) = 'LOAN_DISTRIBUTION_ACCOUNTS'