DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_REMIT_BANK_ACCT_H_V

Line 62493: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

62489: FROM (
62490: SELECT xet.event_id event_id
62491: , 0 line_number
62492: , CASE r
62493: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'

Line 62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

62490: SELECT xet.event_id event_id
62491: , 0 line_number
62492: , CASE r
62493: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'

Line 62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

62491: , 0 line_number
62492: , CASE r
62493: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'

Line 62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

62492: , CASE r
62493: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
62494: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
62495: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
62496: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
62497: WHEN 5 THEN 'AR_RCT_METHOD_H_V'
62498: WHEN 6 THEN 'AR_RCT_METHOD_H_V'
62499: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
62500: WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'

Line 62567: , AR_REMIT_BANK_ACCT_H_V h5

62563: , null source_meaning
62564: FROM xla_events_gt xet
62565: , AR_CASH_RECEIPTS_H_V h1
62566: , AR_RCT_METHOD_H_V h4
62567: , AR_REMIT_BANK_ACCT_H_V h5
62568: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62569: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62570: AND xet.event_class_code = C_EVENT_CLASS_CODE
62571:

Line 62855: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

62851: --
62852: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
62853: --
62854:
62855: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;

62852: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
62853: --
62854:
62855: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;

62853: --
62854:
62855: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

62854:
62855: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
62856: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
62857: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
62858: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
62859: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
62860: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;
62861: TYPE t_array_source_78 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
62862: TYPE t_array_source_79 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 62943: , AR_REMIT_BANK_ACCT_H_V h5

62939: , h1.RCT_TRX_ACCT_REVERSAL source_81
62940: FROM xla_events_gt xet
62941: , AR_CASH_RECEIPTS_H_V h1
62942: , AR_RCT_METHOD_H_V h4
62943: , AR_REMIT_BANK_ACCT_H_V h5
62944: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
62945: and xet.event_class_code = C_EVENT_CLASS_CODE
62946: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
62947: AND h4.event_id (+) = xet.event_id

Line 64022: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'

64018: FROM (
64019: SELECT xet.event_id event_id
64020: , 0 line_number
64021: , CASE r
64022: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

Line 64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'

64019: SELECT xet.event_id event_id
64020: , 0 line_number
64021: , CASE r
64022: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'

Line 64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'

64020: , 0 line_number
64021: , CASE r
64022: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'

Line 64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'

64021: , CASE r
64022: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'

Line 64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'

64022: WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
64023: WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
64024: WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
64025: WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
64026: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
64027: WHEN 6 THEN 'AR_SYSTEM_PARAM_H_V'
64028: WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
64029: WHEN 8 THEN 'AR_RCT_METHOD_H_V'
64030: WHEN 9 THEN 'AR_RCT_METHOD_H_V'

Line 64132: , AR_REMIT_BANK_ACCT_H_V h8

64128: FROM xla_events_gt xet
64129: , AR_CASH_RECEIPTS_H_V h1
64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64133: , AR_SYSTEM_PARAM_H_V h9
64134: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
64135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64136: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 64520: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

64516: --
64517: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64518: --
64519:
64520: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;

64517: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
64518: --
64519:
64520: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;

Line 64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;

64518: --
64519:
64520: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;

Line 64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;

64519:
64520: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;

64520: TYPE t_array_source_1 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
64521: TYPE t_array_source_6 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
64522: TYPE t_array_source_7 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_CONFIRMATION_CCID%TYPE INDEX BY BINARY_INTEGER;
64523: TYPE t_array_source_8 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_REMITTANCE_CCID%TYPE INDEX BY BINARY_INTEGER;
64524: TYPE t_array_source_10 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_UNAPPLIED_CCID%TYPE INDEX BY BINARY_INTEGER;
64525: TYPE t_array_source_11 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_GAIN%TYPE INDEX BY BINARY_INTEGER;
64526: TYPE t_array_source_12 IS TABLE OF AR_SYSTEM_PARAM_H_V.CODE_COMBINATION_ID_LOSS%TYPE INDEX BY BINARY_INTEGER;
64527: TYPE t_array_source_54 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_REMIT_FLAG%TYPE INDEX BY BINARY_INTEGER;
64528: TYPE t_array_source_55 IS TABLE OF AR_RCT_METHOD_H_V.RCT_CLASS_CONFIRM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 64664: , AR_REMIT_BANK_ACCT_H_V h8

64660: FROM xla_events_gt xet
64661: , AR_CASH_RECEIPTS_H_V h1
64662: , AR_RCT_METHOD_H_V h5
64663: , AR_RCT_SITE_USES_H_V h6
64664: , AR_REMIT_BANK_ACCT_H_V h8
64665: , AR_SYSTEM_PARAM_H_V h9
64666: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
64667: and xet.event_class_code = C_EVENT_CLASS_CODE
64668: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id