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

Line 64500: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'

64496: FROM (
64497: SELECT xet.event_id event_id
64498: , 0 line_number
64499: , CASE r
64500: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
64501: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
64502: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
64503: WHEN 4 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
64504: WHEN 5 THEN 'AR_DRAWEE_SITE_USES_H_V'

Line 64501: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

64497: SELECT xet.event_id event_id
64498: , 0 line_number
64499: , CASE r
64500: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
64501: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
64502: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
64503: WHEN 4 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
64504: WHEN 5 THEN 'AR_DRAWEE_SITE_USES_H_V'
64505:

Line 64549: , AR_SYSTEM_PARAM_H_V h5

64545: , null source_meaning
64546: FROM xla_events_gt xet
64547: , AR_DRAWEE_CUSTOMERS_H_V h3
64548: , AR_DRAWEE_SITE_USES_H_V h4
64549: , AR_SYSTEM_PARAM_H_V h5
64550: , AR_TRANSACTIONS_S_V h6
64551: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
64552: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64553: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 64837: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

64833: --
64834: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64835: --
64836:
64837: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_41 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64838: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

64834: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64835: --
64836:
64837: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_39 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
64840: TYPE t_array_source_41 IS TABLE OF AR_DRAWEE_CUSTOMERS_H_V.DRAW_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
64841: TYPE t_array_source_42 IS TABLE OF AR_DRAWEE_SITE_USES_H_V.DRAW_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
64842:

Line 64908: , AR_SYSTEM_PARAM_H_V h5

64904: , h4.DRAW_SITE_SITE_USE_ID source_42
64905: FROM xla_events_gt xet
64906: , AR_DRAWEE_CUSTOMERS_H_V h3
64907: , AR_DRAWEE_SITE_USES_H_V h4
64908: , AR_SYSTEM_PARAM_H_V h5
64909: , AR_TRANSACTIONS_S_V h6
64910: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64911: and xet.event_class_code = C_EVENT_CLASS_CODE
64912: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id

Line 68788: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'

68784: FROM (
68785: SELECT xet.event_id event_id
68786: , 0 line_number
68787: , CASE r
68788: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
68789: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
68790: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
68791: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
68792: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'

Line 68789: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'

68785: SELECT xet.event_id event_id
68786: , 0 line_number
68787: , CASE r
68788: WHEN 1 THEN 'AR_SYSTEM_PARAM_H_V'
68789: WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
68790: WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
68791: WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
68792: WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V'
68793: WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_V'

Line 68843: , AR_SYSTEM_PARAM_H_V h9

68839: FROM xla_events_gt xet
68840: , AR_CM_BILL_SITE_USES_H_V h1
68841: , AR_CM_BILL_TO_CUST_H_V h2
68842: , AR_CREDIT_MEMO_H_V h5
68843: , AR_SYSTEM_PARAM_H_V h9
68844: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
68845: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68846: AND xet.event_class_code = C_EVENT_CLASS_CODE
68847: AND h1.event_id = xet.event_id

Line 69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

69183: --
69184: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69185: --
69186:
69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69189: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

69184: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69185: --
69186:
69187: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
69188: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
69189: TYPE t_array_source_39 IS TABLE OF AR_CREDIT_MEMO_H_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69190: TYPE t_array_source_54 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69191: TYPE t_array_source_60 IS TABLE OF AR_CM_BILL_TO_CUST_H_V.CM_BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
69192: TYPE t_array_source_61 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 69280: , AR_SYSTEM_PARAM_H_V h9

69276: FROM xla_events_gt xet
69277: , AR_CM_BILL_SITE_USES_H_V h1
69278: , AR_CM_BILL_TO_CUST_H_V h2
69279: , AR_CREDIT_MEMO_H_V h5
69280: , AR_SYSTEM_PARAM_H_V h9
69281: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69282: and xet.event_class_code = C_EVENT_CLASS_CODE
69283: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
69284: AND h2.event_id = h1.event_id

Line 79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'

79272: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'

79273: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
79274: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
79275: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79276: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79277: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79278: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79279: WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
79280: WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
79281: WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'

Line 79380: , AR_SYSTEM_PARAM_H_V h9

79376: , AR_CASH_RECEIPTS_H_V h1
79377: , AR_RCT_METHOD_H_V h5
79378: , AR_RCT_SITE_USES_H_V h6
79379: , AR_REMIT_BANK_ACCT_H_V h8
79380: , AR_SYSTEM_PARAM_H_V h9
79381: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
79382: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79383: AND xet.event_class_code = C_EVENT_CLASS_CODE
79384: AND h1.event_id = xet.event_id

Line 79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

79780: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;

Line 79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

79781: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
79782: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
79783: TYPE t_array_source_23 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79784: TYPE t_array_source_24 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79785: TYPE t_array_source_25 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79786: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
79787: TYPE t_array_source_92 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79788: TYPE t_array_source_104 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79789: TYPE t_array_source_105 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79926: , AR_SYSTEM_PARAM_H_V h9

79922: , AR_CASH_RECEIPTS_H_V h1
79923: , AR_RCT_METHOD_H_V h5
79924: , AR_RCT_SITE_USES_H_V h6
79925: , AR_REMIT_BANK_ACCT_H_V h8
79926: , AR_SYSTEM_PARAM_H_V h9
79927: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79928: and xet.event_class_code = C_EVENT_CLASS_CODE
79929: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
79930: AND h5.event_id (+) = h1.event_id