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_00222_AAD_S_000017_PKG dependencies on AR_DRAWEE_SITE_USES_H_V

Line 64504: WHEN 5 THEN 'AR_DRAWEE_SITE_USES_H_V'

64500: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
64501: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
64502: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
64503: WHEN 4 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
64504: WHEN 5 THEN 'AR_DRAWEE_SITE_USES_H_V'
64505:
64506: ELSE null
64507: END object_name
64508: , CASE r

Line 64548: , AR_DRAWEE_SITE_USES_H_V h4

64544: END source_value
64545: , null source_meaning
64546: FROM xla_events_gt xet
64547: , AR_DRAWEE_CUSTOMERS_H_V h3
64548: , AR_DRAWEE_SITE_USES_H_V h4
64549: , AR_SYSTEM_PARAM_H_V h5
64550: , AR_TRANSACTIONS_S_V h6
64551: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
64552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

64837: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_41 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64842:
64843: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64844: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64845: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64907: , AR_DRAWEE_SITE_USES_H_V h4

64903: , h3.DRAW_CUST_ACCOUNT_ID source_41
64904: , h4.DRAW_SITE_SITE_USE_ID source_42
64905: FROM xla_events_gt xet
64906: , AR_DRAWEE_CUSTOMERS_H_V h3
64907: , AR_DRAWEE_SITE_USES_H_V h4
64908: , AR_SYSTEM_PARAM_H_V h5
64909: , AR_TRANSACTIONS_S_V h6
64910: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64911: and xet.event_class_code = C_EVENT_CLASS_CODE