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_000009_PKG dependencies on AR_CREDIT_MEMO_H_V

Line 70315: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'

70311: FROM (
70312: SELECT xet.event_id event_id
70313: , 0 line_number
70314: , CASE r
70315: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
70316: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
70317: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
70318: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
70319: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'

Line 70318: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'

70314: , CASE r
70315: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
70316: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
70317: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
70318: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
70319: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
70320: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
70321: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
70322: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'

Line 70319: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'

70315: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
70316: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
70317: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
70318: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
70319: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
70320: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
70321: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
70322: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
70323:

Line 70322: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'

70318: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
70319: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
70320: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
70321: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
70322: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
70323:
70324: ELSE null
70325: END object_name
70326: , CASE r

Line 70379: , AR_CREDIT_MEMO_H_V h5

70375: , null source_meaning
70376: FROM xla_events_gt xet
70377: , AR_CM_BILL_SITE_USES_H_V h1
70378: , AR_CM_BILL_TO_CUST_H_V h2
70379: , AR_CREDIT_MEMO_H_V h5
70380: , AR_SYSTEM_PARAM_H_V h8
70381: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
70382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70383: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 70698: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

70694: --
70695: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
70696: --
70697:
70698: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
70699: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
70700: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
70701: TYPE t_array_source_34 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70702: TYPE t_array_source_46 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 70701: TYPE t_array_source_34 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

70697:
70698: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
70699: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
70700: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
70701: TYPE t_array_source_34 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70702: TYPE t_array_source_46 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70703: TYPE t_array_source_52 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70704: TYPE t_array_source_53 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 70702: TYPE t_array_source_46 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

70698: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
70699: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
70700: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
70701: TYPE t_array_source_34 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70702: TYPE t_array_source_46 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70703: TYPE t_array_source_52 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70704: TYPE t_array_source_53 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
70706:

Line 70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

70701: TYPE t_array_source_34 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
70702: TYPE t_array_source_46 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70703: TYPE t_array_source_52 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
70704: TYPE t_array_source_53 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
70706:
70707: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 70788: , AR_CREDIT_MEMO_H_V h5

70784: , h5.CM_INVOICING_RULE_ID source_69
70785: FROM xla_events_gt xet
70786: , AR_CM_BILL_SITE_USES_H_V h1
70787: , AR_CM_BILL_TO_CUST_H_V h2
70788: , AR_CREDIT_MEMO_H_V h5
70789: , AR_SYSTEM_PARAM_H_V h8
70790: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70791: and xet.event_class_code = C_EVENT_CLASS_CODE
70792: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id