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_SYSTEM_PARAM_H_V

Line 55700: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

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

Line 55701: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'

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'
55704: WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
55705: WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 55764: , AR_SYSTEM_PARAM_H_V h8

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

Line 56083: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

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

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

Line 56173: , AR_SYSTEM_PARAM_H_V h8

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

Line 64300: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

64296: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64298: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
64299: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
64300: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'

64297: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64298: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
64299: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
64300: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
64301: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
64302: WHEN 10 THEN 'AR_RCT_METHOD_H_V'
64303: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
64304: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
64305: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'

Line 64414: , AR_SYSTEM_PARAM_H_V h9

64410: , AR_CASH_RECEIPTS_H_V h1
64411: , AR_RCT_METHOD_H_V h5
64412: , AR_RCT_SITE_USES_H_V h6
64413: , AR_REMIT_BANK_ACCT_H_V h8
64414: , AR_SYSTEM_PARAM_H_V h9
64415: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
64416: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64417: AND xet.event_class_code = C_EVENT_CLASS_CODE
64418: AND h1.event_id = xet.event_id

Line 64808: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

64804: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64806: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64807: TYPE t_array_source_11 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64808: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

64805: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64806: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNEARNED_CCID%TYPE INDEX BY BINARY_INTEGER;
64807: TYPE t_array_source_11 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64808: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64809: TYPE t_array_source_13 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64810: TYPE t_array_source_56 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64811: TYPE t_array_source_57 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
64812: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
64813: TYPE t_array_source_70 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 64952: , AR_SYSTEM_PARAM_H_V h9

64948: , AR_CASH_RECEIPTS_H_V h1
64949: , AR_RCT_METHOD_H_V h5
64950: , AR_RCT_SITE_USES_H_V h6
64951: , AR_REMIT_BANK_ACCT_H_V h8
64952: , AR_SYSTEM_PARAM_H_V h9
64953: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64954: and xet.event_class_code = C_EVENT_CLASS_CODE
64955: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
64956: AND h5.event_id (+) = h1.event_id