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_CM_BILL_SITE_USES_H_V

Line 68793: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_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
68796: END object_name
68797: , CASE r

Line 68840: , AR_CM_BILL_SITE_USES_H_V h1

68836: ELSE null
68837: END source_value
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)

Line 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;

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;
69195: TYPE t_array_source_2 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69196: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 69277: , AR_CM_BILL_SITE_USES_H_V h1

69273: , h5.CM_INVOICE_CURRENCY_CODE source_54
69274: , h2.CM_BILL_CUST_ACCOUNT_ID source_60
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