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_SYSTEM_PARAM_H_V

Line 70316: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

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

Line 70317: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'

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'
70320: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
70321: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 70380: , AR_SYSTEM_PARAM_H_V h8

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

Line 70699: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

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

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

Line 70789: , AR_SYSTEM_PARAM_H_V h8

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

Line 79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

79322: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'

Line 79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'

79323: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79324: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79440: , AR_SYSTEM_PARAM_H_V h10

79436: , AR_CASH_RECEIPTS_H_V h2
79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79440: , AR_SYSTEM_PARAM_H_V h10
79441: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
79442: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79443: AND xet.event_class_code = C_EVENT_CLASS_CODE
79444: AND h2.event_id = xet.event_id

Line 79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

79869: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

79870: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
79871: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 80031: , AR_SYSTEM_PARAM_H_V h10

80027: , AR_CASH_RECEIPTS_H_V h2
80028: , AR_RCT_METHOD_H_V h6
80029: , AR_RCT_SITE_USES_H_V h7
80030: , AR_REMIT_BANK_ACCT_H_V h9
80031: , AR_SYSTEM_PARAM_H_V h10
80032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80033: and xet.event_class_code = C_EVENT_CLASS_CODE
80034: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
80035: AND h6.event_id (+) = h2.event_id