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_000008_PKG dependencies on AR_SYSTEM_PARAM_H_V

Line 55429: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

55425: SELECT xet.event_id event_id
55426: , 0 line_number
55427: , CASE r
55428: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
55429: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55430: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55431: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55432: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55433: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'

Line 55430: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'

55426: , 0 line_number
55427: , CASE r
55428: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
55429: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
55430: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
55431: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
55432: WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
55433: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55434: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 55493: , AR_SYSTEM_PARAM_H_V h8

55489: FROM xla_events_gt xet
55490: , AR_CM_BILL_SITE_USES_H_V h1
55491: , AR_CM_BILL_TO_CUST_H_V h2
55492: , AR_CREDIT_MEMO_H_V h5
55493: , AR_SYSTEM_PARAM_H_V h8
55494: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
55495: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55496: AND xet.event_class_code = C_EVENT_CLASS_CODE
55497: AND h1.event_id = xet.event_id

Line 55812: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

55808: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
55809: --
55810:
55811: TYPE t_array_source_5 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
55812: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
55813: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
55814: TYPE t_array_source_25 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
55815: TYPE t_array_source_37 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55816: TYPE t_array_source_43 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 55813: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

55809: --
55810:
55811: TYPE t_array_source_5 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
55812: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
55813: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
55814: TYPE t_array_source_25 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
55815: TYPE t_array_source_37 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55816: TYPE t_array_source_43 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
55817: TYPE t_array_source_44 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 55902: , AR_SYSTEM_PARAM_H_V h8

55898: FROM xla_events_gt xet
55899: , AR_CM_BILL_SITE_USES_H_V h1
55900: , AR_CM_BILL_TO_CUST_H_V h2
55901: , AR_CREDIT_MEMO_H_V h5
55902: , AR_SYSTEM_PARAM_H_V h8
55903: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55904: and xet.event_class_code = C_EVENT_CLASS_CODE
55905: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
55906: AND h2.event_id = h1.event_id

Line 64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'

64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'

64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'
64031: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
64032: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64133: , AR_SYSTEM_PARAM_H_V h9

64129: , AR_CASH_RECEIPTS_H_V h1
64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64133: , AR_SYSTEM_PARAM_H_V h9
64134: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
64135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64136: AND xet.event_class_code = C_EVENT_CLASS_CODE
64137: AND h1.event_id = xet.event_id

Line 64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64529: TYPE t_array_source_56 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64530: TYPE t_array_source_68 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 64665: , AR_SYSTEM_PARAM_H_V h9

64661: , AR_CASH_RECEIPTS_H_V h1
64662: , AR_RCT_METHOD_H_V h5
64663: , AR_RCT_SITE_USES_H_V h6
64664: , AR_REMIT_BANK_ACCT_H_V h8
64665: , AR_SYSTEM_PARAM_H_V h9
64666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64667: and xet.event_class_code = C_EVENT_CLASS_CODE
64668: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
64669: AND h5.event_id (+) = h1.event_id