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_CREDIT_MEMO_H_V

Line 68790: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'

68786: , 0 line_number
68787: , CASE r
68788: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
68789: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
68790: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
68791: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
68792: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
68793: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'
68794:

Line 68791: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'

68787: , CASE r
68788: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
68789: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
68790: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
68791: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
68792: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
68793: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'
68794:
68795: ELSE null

Line 68842: , AR_CREDIT_MEMO_H_V h5

68838: , null source_meaning
68839: FROM xla_events_gt xet
68840: , AR_CM_BILL_SITE_USES_H_V h1
68841: , AR_CM_BILL_TO_CUST_H_V h2
68842: , AR_CREDIT_MEMO_H_V h5
68843: , AR_SYSTEM_PARAM_H_V h9
68844: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
68845: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68846: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 69189: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

69185: --
69186:
69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69189: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69193:

Line 69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

69186:
69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69189: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
69193:
69194: TYPE t_array_source_1 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 69279: , AR_CREDIT_MEMO_H_V h5

69275: , h1.CM_BILL_USES_SITE_USE_ID source_61
69276: FROM xla_events_gt xet
69277: , AR_CM_BILL_SITE_USES_H_V h1
69278: , AR_CM_BILL_TO_CUST_H_V h2
69279: , AR_CREDIT_MEMO_H_V h5
69280: , AR_SYSTEM_PARAM_H_V h9
69281: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69282: and xet.event_class_code = C_EVENT_CLASS_CODE
69283: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id