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

Line 68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'

68015: , 0 line_number
68016: , CASE r
68017: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68018: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68022: WHEN 6 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
68023: WHEN 7 THEN 'AR_DRAWEE_SITE_USES_H_V'

Line 68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'

68016: , CASE r
68017: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
68018: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
68019: WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
68020: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
68021: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
68022: WHEN 6 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
68023: WHEN 7 THEN 'AR_DRAWEE_SITE_USES_H_V'
68024:

Line 68076: , AR_SYSTEM_PARAM_H_V h5

68072: , null source_meaning
68073: FROM xla_events_gt xet
68074: , AR_DRAWEE_CUSTOMERS_H_V h3
68075: , AR_DRAWEE_SITE_USES_H_V h4
68076: , AR_SYSTEM_PARAM_H_V h5
68077: , AR_TRANSACTIONS_S_V h6
68078: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68079: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68080: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

68362: --
68363:
68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68369: TYPE t_array_source_53 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68370: TYPE t_array_source_54 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

68363:
68364: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
68365: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68366: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
68367: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
68368: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
68369: TYPE t_array_source_53 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
68370: TYPE t_array_source_54 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
68371:

Line 68441: , AR_SYSTEM_PARAM_H_V h5

68437: , h4.DRAW_SITE_SITE_USE_ID source_54
68438: FROM xla_events_gt xet
68439: , AR_DRAWEE_CUSTOMERS_H_V h3
68440: , AR_DRAWEE_SITE_USES_H_V h4
68441: , AR_SYSTEM_PARAM_H_V h5
68442: , AR_TRANSACTIONS_S_V h6
68443: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68444: and xet.event_class_code = C_EVENT_CLASS_CODE
68445: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id

Line 72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'

72447: , CASE r
72448: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'
72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'
72455: WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'

Line 72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'

72448: WHEN 1 THEN 'AR_CREDIT_MEMO_H_V'
72449: WHEN 2 THEN 'AR_CREDIT_MEMO_H_V'
72450: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
72451: WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
72452: WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
72453: WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
72454: WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'
72455: WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'
72456: WHEN 9 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 72518: , AR_SYSTEM_PARAM_H_V h8

72514: FROM xla_events_gt xet
72515: , AR_CM_BILL_SITE_USES_H_V h1
72516: , AR_CM_BILL_TO_CUST_H_V h2
72517: , AR_CREDIT_MEMO_H_V h5
72518: , AR_SYSTEM_PARAM_H_V h8
72519: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72521: AND xet.event_class_code = C_EVENT_CLASS_CODE
72522: AND h1.event_id = xet.event_id

Line 72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

72853:
72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

72854: TYPE t_array_source_7 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72855: TYPE t_array_source_8 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72856: TYPE t_array_source_9 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72857: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
72858: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
72859: TYPE t_array_source_51 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
72860: TYPE t_array_source_66 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72861: TYPE t_array_source_72 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
72862: TYPE t_array_source_73 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 72954: , AR_SYSTEM_PARAM_H_V h8

72950: FROM xla_events_gt xet
72951: , AR_CM_BILL_SITE_USES_H_V h1
72952: , AR_CM_BILL_TO_CUST_H_V h2
72953: , AR_CREDIT_MEMO_H_V h5
72954: , AR_SYSTEM_PARAM_H_V h8
72955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72956: and xet.event_class_code = C_EVENT_CLASS_CODE
72957: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
72958: AND h2.event_id = h1.event_id

Line 83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'

83204: WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V'
83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

83205: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
83206: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
83207: WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
83208: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
83209: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
83210: WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
83211: WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
83212: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
83213: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

Line 83323: , AR_SYSTEM_PARAM_H_V h9

83319: , AR_CASH_RECEIPTS_H_V h1
83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83323: , AR_SYSTEM_PARAM_H_V h9
83324: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
83325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
83326: AND xet.event_class_code = C_EVENT_CLASS_CODE
83327: AND h1.event_id = xet.event_id

Line 83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

83722: TYPE t_array_source_20 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

83723: TYPE t_array_source_21 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83724: TYPE t_array_source_22 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
83725: TYPE t_array_source_23 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
83726: TYPE t_array_source_34 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
83727: TYPE t_array_source_35 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
83728: TYPE t_array_source_36 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83729: TYPE t_array_source_37 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNIDENTIFIED_CCID%TYPE INDEX BY BINARY_INTEGER;
83730: TYPE t_array_source_101 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
83731: TYPE t_array_source_112 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 83875: , AR_SYSTEM_PARAM_H_V h9

83871: , AR_CASH_RECEIPTS_H_V h1
83872: , AR_RCT_METHOD_H_V h5
83873: , AR_RCT_SITE_USES_H_V h6
83874: , AR_REMIT_BANK_ACCT_H_V h8
83875: , AR_SYSTEM_PARAM_H_V h9
83876: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
83877: and xet.event_class_code = C_EVENT_CLASS_CODE
83878: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
83879: AND h5.event_id (+) = h1.event_id