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

Line 72448: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'

72444: FROM (
72445: SELECT xet.event_id event_id
72446: , 0 line_number
72447: , CASE r
72448: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'
72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'

Line 72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'

72445: SELECT xet.event_id event_id
72446: , 0 line_number
72447: , CASE r
72448: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'
72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'

Line 72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'

72446: , 0 line_number
72447: , CASE r
72448: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'
72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'

Line 72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'

72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'
72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'
72455: WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'
72456: WHEN 9 THEN 'AR_CM_BILL_SITE_USES_H_V'
72457:

Line 72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'

72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'
72455: WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'
72456: WHEN 9 THEN 'AR_CM_BILL_SITE_USES_H_V'
72457:
72458: ELSE null

Line 72517: , AR_CREDIT_MEMO_H_V h5

72513: , null source_meaning
72514: FROM xla_events_gt xet
72515: , AR_CM_BILL_SITE_USES_H_V h1
72516: , AR_CM_BILL_TO_CUST_H_V h2
72517: , AR_CREDIT_MEMO_H_V h5
72518: , AR_SYSTEM_PARAM_H_V h8
72519: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72521: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

72850: --
72851: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72852: --
72853:
72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

Line 72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

72851: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
72852: --
72853:
72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

72852: --
72853:
72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72863:

Line 72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
72863:
72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 72953: , AR_CREDIT_MEMO_H_V h5

72949: , h1.CM_BILL_USES_SITE_USE_ID source_73
72950: FROM xla_events_gt xet
72951: , AR_CM_BILL_SITE_USES_H_V h1
72952: , AR_CM_BILL_TO_CUST_H_V h2
72953: , AR_CREDIT_MEMO_H_V h5
72954: , AR_SYSTEM_PARAM_H_V h8
72955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72956: and xet.event_class_code = C_EVENT_CLASS_CODE
72957: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id