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

Line 69435: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'

69431: FROM (
69432: SELECT xet.event_id event_id
69433: , 0 line_number
69434: , CASE r
69435: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
69436: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
69437: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
69438: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
69439: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'

Line 69436: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

69432: SELECT xet.event_id event_id
69433: , 0 line_number
69434: , CASE r
69435: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
69436: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
69437: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
69438: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
69439: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
69440: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 69490: , AR_SYSTEM_PARAM_H_V h8

69486: FROM xla_events_gt xet
69487: , AR_CM_BILL_SITE_USES_H_V h1
69488: , AR_CM_BILL_TO_CUST_H_V h2
69489: , AR_CREDIT_MEMO_H_V h5
69490: , AR_SYSTEM_PARAM_H_V h8
69491: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
69492: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69493: AND xet.event_class_code = C_EVENT_CLASS_CODE
69494: AND h1.event_id = xet.event_id

Line 69826: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

69822: --
69823: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69824: --
69825:
69826: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69827: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69828: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69829: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69830: 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 69827: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

69823: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69824: --
69825:
69826: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69827: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69828: TYPE t_array_source_32 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69829: TYPE t_array_source_44 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69830: 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;
69831: 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 69917: , AR_SYSTEM_PARAM_H_V h8

69913: FROM xla_events_gt xet
69914: , AR_CM_BILL_SITE_USES_H_V h1
69915: , AR_CM_BILL_TO_CUST_H_V h2
69916: , AR_CREDIT_MEMO_H_V h5
69917: , AR_SYSTEM_PARAM_H_V h8
69918: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69919: and xet.event_class_code = C_EVENT_CLASS_CODE
69920: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
69921: AND h2.event_id = h1.event_id

Line 78549: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'

78545: FROM (
78546: SELECT xet.event_id event_id
78547: , 0 line_number
78548: , CASE r
78549: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
78550: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
78551: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78552: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78550: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

78546: SELECT xet.event_id event_id
78547: , 0 line_number
78548: , CASE r
78549: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
78550: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
78551: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
78552: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
78553: WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V'
78554: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'

Line 78644: , AR_SYSTEM_PARAM_H_V h9

78640: FROM xla_events_gt xet
78641: , AR_CASH_RECEIPTS_H_V h2
78642: , AR_RCT_SITE_USES_H_V h6
78643: , AR_REMIT_BANK_ACCT_H_V h8
78644: , AR_SYSTEM_PARAM_H_V h9
78645: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
78646: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78647: AND xet.event_class_code = C_EVENT_CLASS_CODE
78648: AND h2.event_id = xet.event_id

Line 79084: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

79080: --
79081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79082: --
79083:
79084: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79085: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79086: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79087: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79088: 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 79085: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

79081: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
79082: --
79083:
79084: TYPE t_array_source_7 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79085: TYPE t_array_source_8 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79086: TYPE t_array_source_17 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79087: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79088: TYPE t_array_source_58 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79089: TYPE t_array_source_72 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 79239: , AR_SYSTEM_PARAM_H_V h9

79235: FROM xla_events_gt xet
79236: , AR_CASH_RECEIPTS_H_V h2
79237: , AR_RCT_SITE_USES_H_V h6
79238: , AR_REMIT_BANK_ACCT_H_V h8
79239: , AR_SYSTEM_PARAM_H_V h9
79240: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79241: and xet.event_class_code = C_EVENT_CLASS_CODE
79242: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
79243: AND h6.event_id (+) = h2.event_id