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

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

5948: FROM xla_events_gt xet
5949: , LNS_LOAN_HEADERS_EXT_V h2
5950: , fnd_lookup_values fvl1
5951: , fnd_lookup_values fvl15
5952: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5954: AND xet.event_type_code = C_EVENT_TYPE_CODE
5955: AND h2.event_id = xet.event_id
5956: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

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

6109: , fnd_lookup_values fvl4
6110: , fnd_lookup_values fvl8
6111: , fnd_lookup_values fvl9
6112: , fnd_lookup_values fvl13
6113: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
6114: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6115: AND xet.event_type_code = C_EVENT_TYPE_CODE
6116: AND l1.event_id = xet.event_id
6117: AND fvl4.lookup_type(+) = 'LOAN_DISTRIBUTION_ACCOUNTS'

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

7353: FROM xla_events_gt xet
7354: , LNS_LOAN_HEADERS_EXT_V h2
7355: , fnd_lookup_values fvl1
7356: , fnd_lookup_values fvl15
7357: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7359: AND xet.event_type_code = C_EVENT_TYPE_CODE
7360: AND h2.event_id = xet.event_id
7361: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

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

7509: , fnd_lookup_values fvl4
7510: , fnd_lookup_values fvl8
7511: , fnd_lookup_values fvl9
7512: , fnd_lookup_values fvl13
7513: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7515: AND xet.event_type_code = C_EVENT_TYPE_CODE
7516: AND l1.event_id = xet.event_id
7517: AND fvl4.lookup_type(+) = 'LOAN_DISTRIBUTION_ACCOUNTS'