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_SYSTEM_PARAM_H_V

Line 71557: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

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'
71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'

Line 71558: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'

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'
71561: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
71562: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 71621: , AR_SYSTEM_PARAM_H_V h8

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
71625: AND h1.event_id = xet.event_id

Line 71940: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

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

Line 71941: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%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;
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;

Line 72030: , AR_SYSTEM_PARAM_H_V h8

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
72034: AND h2.event_id = h1.event_id

Line 80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'

80571: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'

Line 80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'

80572: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
80573: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
80574: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
80575: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
80576: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
80577: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
80578: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
80579: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
80580: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 80681: , AR_SYSTEM_PARAM_H_V h10

80677: , AR_CASH_RECEIPTS_H_V h2
80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80681: , AR_SYSTEM_PARAM_H_V h10
80682: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
80683: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80684: AND xet.event_class_code = C_EVENT_CLASS_CODE
80685: AND h2.event_id = xet.event_id

Line 81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

81108: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

81109: TYPE t_array_source_14 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
81110: TYPE t_array_source_15 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
81111: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
81112: TYPE t_array_source_18 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
81113: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
81114: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
81115: TYPE t_array_source_70 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
81116: TYPE t_array_source_71 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
81117: TYPE t_array_source_76 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 81266: , AR_SYSTEM_PARAM_H_V h10

81262: , AR_CASH_RECEIPTS_H_V h2
81263: , AR_RCT_METHOD_H_V h6
81264: , AR_RCT_SITE_USES_H_V h7
81265: , AR_REMIT_BANK_ACCT_H_V h9
81266: , AR_SYSTEM_PARAM_H_V h10
81267: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
81268: and xet.event_class_code = C_EVENT_CLASS_CODE
81269: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
81270: AND h6.event_id (+) = h2.event_id