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_000009_PKG dependencies on AR_RCT_METHOD_H_V

Line 77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

77480: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

77481: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
77482: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
77483: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
77484: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
77485: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
77486: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77487: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
77488: WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
77489: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'

Line 77553: , AR_RCT_METHOD_H_V h4

77549: END source_value
77550: , null source_meaning
77551: FROM xla_events_gt xet
77552: , AR_CASH_RECEIPTS_H_V h1
77553: , AR_RCT_METHOD_H_V h4
77554: , AR_REMIT_BANK_ACCT_H_V h5
77555: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77557: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

77873: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
77874: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

77874: TYPE t_array_source_3 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
77875: TYPE t_array_source_5 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
77876: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
77877: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
77878: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
77879: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;

Line 77972: , AR_RCT_METHOD_H_V h4

77968: , h1.RCT_DOC_SEQUENCE_VALUE source_90
77969: , h1.RCT_TRX_ACCT_REVERSAL source_91
77970: FROM xla_events_gt xet
77971: , AR_CASH_RECEIPTS_H_V h1
77972: , AR_RCT_METHOD_H_V h4
77973: , AR_REMIT_BANK_ACCT_H_V h5
77974: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77975: and xet.event_class_code = C_EVENT_CLASS_CODE
77976: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id

Line 79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'

79325: WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'

79326: WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
79327: WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
79328: WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
79329: WHEN 11 THEN 'AR_RCT_METHOD_H_V'
79330: WHEN 12 THEN 'AR_RCT_METHOD_H_V'
79331: WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
79332: WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
79333: WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
79334: WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'

Line 79437: , AR_RCT_METHOD_H_V h6

79433: END source_value
79434: , null source_meaning
79435: FROM xla_events_gt xet
79436: , AR_CASH_RECEIPTS_H_V h2
79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79440: , AR_SYSTEM_PARAM_H_V h10
79441: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)

Line 79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

79872: TYPE t_array_source_18 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

79873: TYPE t_array_source_19 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
79874: TYPE t_array_source_20 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
79875: TYPE t_array_source_60 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_XLA_APPLIED_TO_APP_ID%TYPE INDEX BY BINARY_INTEGER;
79876: TYPE t_array_source_72 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
79877: TYPE t_array_source_73 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
79878: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_PAY_FROM_CUSTOMER%TYPE INDEX BY BINARY_INTEGER;
79879: TYPE t_array_source_79 IS TABLE OF AR_RCT_SITE_USES_H_V.RCT_SITE_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
79880: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_APP_STATUS%TYPE INDEX BY BINARY_INTEGER;
79881: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 80028: , AR_RCT_METHOD_H_V h6

80024: , h2.RCT_DOC_SEQUENCE_VALUE source_90
80025: , h2.RCT_TRX_ACCT_REVERSAL source_91
80026: FROM xla_events_gt xet
80027: , AR_CASH_RECEIPTS_H_V h2
80028: , AR_RCT_METHOD_H_V h6
80029: , AR_RCT_SITE_USES_H_V h7
80030: , AR_REMIT_BANK_ACCT_H_V h9
80031: , AR_SYSTEM_PARAM_H_V h10
80032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date