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

Line 71556: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'

71552: FROM (
71553: SELECT xet.event_id event_id
71554: , 0 line_number
71555: , CASE r
71556: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
71557: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
71558: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
71559: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
71560: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'

Line 71559: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'

71555: , CASE r
71556: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
71557: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
71558: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
71559: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
71560: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
71562: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
71563: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'

Line 71560: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'

71556: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
71557: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
71558: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
71559: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
71560: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
71562: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
71563: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
71564:

Line 71563: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'

71559: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
71560: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
71562: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
71563: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
71564:
71565: ELSE null
71566: END object_name
71567: , CASE r

Line 71620: , AR_CREDIT_MEMO_H_V h5

71616: , null source_meaning
71617: FROM xla_events_gt xet
71618: , AR_CM_BILL_SITE_USES_H_V h1
71619: , AR_CM_BILL_TO_CUST_H_V h2
71620: , AR_CREDIT_MEMO_H_V h5
71621: , AR_SYSTEM_PARAM_H_V h8
71622: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
71623: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71624: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71939: TYPE t_array_source_12 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;

71935: --
71936: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
71937: --
71938:
71939: TYPE t_array_source_12 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
71940: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
71941: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
71942: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71943: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 71942: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

71938:
71939: TYPE t_array_source_12 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
71940: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
71941: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
71942: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71943: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71944: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71945: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71943: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

71939: TYPE t_array_source_12 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
71940: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
71941: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
71942: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71943: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71944: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71945: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
71947:

Line 71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

71942: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
71943: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71944: TYPE t_array_source_50 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
71945: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
71947:
71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72029: , AR_CREDIT_MEMO_H_V h5

72025: , h5.CM_INVOICING_RULE_ID source_67
72026: FROM xla_events_gt xet
72027: , AR_CM_BILL_SITE_USES_H_V h1
72028: , AR_CM_BILL_TO_CUST_H_V h2
72029: , AR_CREDIT_MEMO_H_V h5
72030: , AR_SYSTEM_PARAM_H_V h8
72031: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72032: and xet.event_class_code = C_EVENT_CLASS_CODE
72033: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id