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

Line 55699: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'

55695: FROM (
55696: SELECT xet.event_id event_id
55697: , 0 line_number
55698: , CASE r
55699: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
55700: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55701: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55702: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55703: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'

Line 55702: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'

55698: , CASE r
55699: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
55700: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55701: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55702: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55703: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55704: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55705: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
55706: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'

Line 55703: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'

55699: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
55700: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55701: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55702: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55703: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55704: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55705: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
55706: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
55707:

Line 55706: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'

55702: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55703: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55704: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55705: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
55706: WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
55707:
55708: ELSE null
55709: END object_name
55710: , CASE r

Line 55763: , AR_CREDIT_MEMO_H_V h5

55759: , null source_meaning
55760: FROM xla_events_gt xet
55761: , AR_CM_BILL_SITE_USES_H_V h1
55762: , AR_CM_BILL_TO_CUST_H_V h2
55763: , AR_CREDIT_MEMO_H_V h5
55764: , AR_SYSTEM_PARAM_H_V h8
55765: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
55766: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55767: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

56078: --
56079: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
56080: --
56081:
56082: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
56083: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
56084: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
56085: TYPE t_array_source_27 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
56086: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 56085: TYPE t_array_source_27 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

56081:
56082: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
56083: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
56084: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
56085: TYPE t_array_source_27 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
56086: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
56087: TYPE t_array_source_45 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
56088: TYPE t_array_source_46 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 56086: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

56082: TYPE t_array_source_2 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
56083: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
56084: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
56085: TYPE t_array_source_27 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
56086: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
56087: TYPE t_array_source_45 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
56088: TYPE t_array_source_46 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
56090:

Line 56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;

56085: TYPE t_array_source_27 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
56086: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
56087: TYPE t_array_source_45 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
56088: TYPE t_array_source_46 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
56089: TYPE t_array_source_52 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
56090:
56091: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 56172: , AR_CREDIT_MEMO_H_V h5

56168: , h5.CM_INVOICING_RULE_ID source_52
56169: FROM xla_events_gt xet
56170: , AR_CM_BILL_SITE_USES_H_V h1
56171: , AR_CM_BILL_TO_CUST_H_V h2
56172: , AR_CREDIT_MEMO_H_V h5
56173: , AR_SYSTEM_PARAM_H_V h8
56174: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
56175: and xet.event_class_code = C_EVENT_CLASS_CODE
56176: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id