[Home] [Help]
77764: , 0 line_number
77765: , CASE r
77766: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
77767: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
77768: WHEN 3 THEN 'AR_RCT_METHOD_H_V'
77769: WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
77770: WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
77771: WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
77772: WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
77840: END source_value
77841: , null source_meaning
77842: FROM xla_events_gt xet
77843: , AR_CASH_RECEIPTS_H_V h1
77844: , AR_RCT_METHOD_H_V h4
77845: , AR_RECEIVABLES_TRX_MISC_H_V h5
77846: , AR_REMIT_BANK_ACCT_H_V h6
77847: ,(select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
77848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78136: --
78137:
78138: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78139: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
78140: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%TYPE INDEX BY BINARY_INTEGER;
78141: TYPE t_array_source_11 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_DATE%TYPE INDEX BY BINARY_INTEGER;
78142: TYPE t_array_source_12 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BANK_NAME%TYPE INDEX BY BINARY_INTEGER;
78143: TYPE t_array_source_13 IS TABLE OF AR_REMIT_BANK_ACCT_H_V.RMT_BNK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
78144: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_CASH_RECEIPT_ID%TYPE INDEX BY BINARY_INTEGER;
78224: , h1.RCT_DOC_SEQUENCE_ID source_118
78225: , h1.RCT_TRX_ACCT_REVERSAL source_119
78226: FROM xla_events_gt xet
78227: , AR_CASH_RECEIPTS_H_V h1
78228: , AR_RCT_METHOD_H_V h4
78229: , AR_RECEIVABLES_TRX_MISC_H_V h5
78230: , AR_REMIT_BANK_ACCT_H_V h6
78231: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78232: and xet.event_class_code = C_EVENT_CLASS_CODE
79267: , 0 line_number
79268: , CASE r
79269: WHEN 1 THEN 'AR_CASH_RECEIPTS_H_V'
79270: WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V'
79271: WHEN 3 THEN 'AR_RCT_METHOD_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'
79373: END source_value
79374: , null source_meaning
79375: FROM xla_events_gt xet
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)
79775: --
79776:
79777: TYPE t_array_source_8 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_RECEIPT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
79778: TYPE t_array_source_9 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79779: TYPE t_array_source_10 IS TABLE OF AR_RCT_METHOD_H_V.RCT_MTHD_NAME%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;
79919: , h1.RCT_DOC_SEQUENCE_ID source_118
79920: , h1.RCT_TRX_ACCT_REVERSAL source_119
79921: FROM xla_events_gt xet
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