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_DISTRIBUTIONS_L_V

Line 66687: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

66683: FROM (
66684: SELECT xet.event_id event_id
66685: , l5.line_number line_number
66686: , CASE r
66687: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

66684: SELECT xet.event_id event_id
66685: , l5.line_number line_number
66686: , CASE r
66687: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

66685: , l5.line_number line_number
66686: , CASE r
66687: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

66686: , CASE r
66687: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

66687: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

66688: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
66689: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
66690: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
66691: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
66692: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
66693: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
66694: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
66695: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
66696: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 66760: , AR_DISTRIBUTIONS_L_V l5

66756: END source_value
66757: , null source_meaning
66758: FROM xla_events_gt xet
66759: , AR_DISTRIBUTIONS_BASE_V l4
66760: , AR_DISTRIBUTIONS_L_V l5
66761: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66762: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66763: AND xet.event_class_code = C_EVENT_CLASS_CODE
66764: AND l4.event_id = xet.event_id

Line 66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

66905: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

66906: TYPE t_array_source_117 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

66907: TYPE t_array_source_118 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

66908:
66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

66909: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

66910: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
66911: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
66912: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66913: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
66914: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
66915: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
66916: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
66917: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
66918: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 67037: , AR_DISTRIBUTIONS_L_V l5

67033: , l4.DIST_CUR_CONVERSION_TYPE source_47
67034: , l4.DIST_TO_ACCTD_AMT source_48
67035: FROM xla_events_gt xet
67036: , AR_DISTRIBUTIONS_BASE_V l4
67037: , AR_DISTRIBUTIONS_L_V l5
67038: WHERE xet.event_id between x_first_event_id and x_last_event_id
67039: and xet.event_date between p_pad_start_date and p_pad_end_date
67040: and xet.event_class_code = C_EVENT_CLASS_CODE
67041: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

Line 68151: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

68147: FROM (
68148: SELECT xet.event_id event_id
68149: , l2.line_number line_number
68150: , CASE r
68151: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

68148: SELECT xet.event_id event_id
68149: , l2.line_number line_number
68150: , CASE r
68151: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

68149: , l2.line_number line_number
68150: , CASE r
68151: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

68150: , CASE r
68151: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

68151: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

68152: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
68153: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
68154: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
68155: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
68156: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
68157: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
68158: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
68159: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
68160: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 68224: , AR_DISTRIBUTIONS_L_V l2

68220: END source_value
68221: , null source_meaning
68222: FROM xla_events_gt xet
68223: , AR_DISTRIBUTIONS_BASE_V l1
68224: , AR_DISTRIBUTIONS_L_V l2
68225: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
68226: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68227: AND xet.event_class_code = C_EVENT_CLASS_CODE
68228: AND l1.event_id = xet.event_id

Line 68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%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:
68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_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:
68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_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:
68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

68371:
68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

68372: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

68373: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
68374: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68375: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68376: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68377: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68378: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68379: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68380: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68381: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 68496: , AR_DISTRIBUTIONS_L_V l2

68492: , l1.DIST_CUR_CONVERSION_TYPE source_47
68493: , l1.DIST_ACCTD_AMT source_52
68494: FROM xla_events_gt xet
68495: , AR_DISTRIBUTIONS_BASE_V l1
68496: , AR_DISTRIBUTIONS_L_V l2
68497: WHERE xet.event_id between x_first_event_id and x_last_event_id
68498: and xet.event_date between p_pad_start_date and p_pad_end_date
68499: and xet.event_class_code = C_EVENT_CLASS_CODE
68500: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

72592: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
72593: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
72598: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
72599: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
72600: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

Line 72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

72593: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
72594: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
72598: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
72599: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
72600: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
72601: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

Line 72599: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

72595: WHEN 4 THEN 'AR_CM_LINES_L_V'
72596: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
72597: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
72598: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
72599: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
72600: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
72601: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
72602: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
72603: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

Line 72706: , AR_DISTRIBUTIONS_L_V l6

72702: , null source_meaning
72703: FROM xla_events_gt xet
72704: , AR_CM_LINES_BASE_V l3
72705: , AR_CM_LINES_L_V l4
72706: , AR_DISTRIBUTIONS_L_V l6
72707: , AR_RECEIVABLES_TRX_ACT_S_V l7
72708: , AR_TRANSACTIONS_S_V l9
72709: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72710: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

72864: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72870: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
72871: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
72872: TYPE t_array_source_64 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

Line 72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

72865: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72866: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72870: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
72871: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
72872: TYPE t_array_source_64 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
72873: TYPE t_array_source_65 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72871: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

72867: TYPE t_array_source_24 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72868: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
72869: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72870: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
72871: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
72872: TYPE t_array_source_64 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
72873: TYPE t_array_source_65 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
72874: TYPE t_array_source_67 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72875: TYPE t_array_source_68 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 73017: , AR_DISTRIBUTIONS_L_V l6

73013: , l4.CM_LINE_DIST_AMT source_76
73014: FROM xla_events_gt xet
73015: , AR_CM_LINES_BASE_V l3
73016: , AR_CM_LINES_L_V l4
73017: , AR_DISTRIBUTIONS_L_V l6
73018: , AR_RECEIVABLES_TRX_ACT_S_V l7
73019: , AR_TRANSACTIONS_S_V l9
73020: WHERE xet.event_id between x_first_event_id and x_last_event_id
73021: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 81874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

81870: FROM (
81871: SELECT xet.event_id event_id
81872: , l3.line_number line_number
81873: , CASE r
81874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

81871: SELECT xet.event_id event_id
81872: , l3.line_number line_number
81873: , CASE r
81874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

81872: , l3.line_number line_number
81873: , CASE r
81874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

81873: , CASE r
81874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

81874: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

81875: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
81876: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
81877: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
81878: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

81879: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
81880: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
81881: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
81882: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
81883: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
81884: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
81885:
81886: ELSE null
81887: END object_name

Line 81952: , AR_DISTRIBUTIONS_L_V l3

81948: END source_value
81949: , null source_meaning
81950: FROM xla_events_gt xet
81951: , AR_DISTRIBUTIONS_BASE_V l2
81952: , AR_DISTRIBUTIONS_L_V l3
81953: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
81954: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
81955: AND xet.event_class_code = C_EVENT_CLASS_CODE
81956: AND l2.event_id = xet.event_id

Line 82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

82098: TYPE t_array_source_125 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

82099: TYPE t_array_source_126 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

82100: TYPE t_array_source_127 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

82101:
82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

82102: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

82103: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
82104: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
82105: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82106: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

82107: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
82108: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
82109: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
82110: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
82111: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
82112: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
82113:
82114: l_array_source_16 t_array_source_16;
82115: l_array_source_18 t_array_source_18;

Line 82231: , AR_DISTRIBUTIONS_L_V l3

82227: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_99
82228: , l2.DIST_TO_CUR_CONVERSION_DATE source_100
82229: FROM xla_events_gt xet
82230: , AR_DISTRIBUTIONS_BASE_V l2
82231: , AR_DISTRIBUTIONS_L_V l3
82232: WHERE xet.event_id between x_first_event_id and x_last_event_id
82233: and xet.event_date between p_pad_start_date and p_pad_end_date
82234: and xet.event_class_code = C_EVENT_CLASS_CODE
82235: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

83397: , CASE r
83398: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

83398: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

83399: WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
83400: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

83401: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

83402: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

83403: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

83404: WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
83405: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
83406: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
83407: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
83408: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
83409: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'

83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'

83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'

83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'

83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'

83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'
83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'
83427: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'

Line 83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'

83420: WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
83421: WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
83422: WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'
83427: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
83428:

Line 83427: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'

83423: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
83424: WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
83425: WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
83426: WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'
83427: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
83428:
83429: ELSE null
83430: END object_name
83431: , CASE r

Line 83572: , AR_DISTRIBUTIONS_L_V l4

83568: , null source_meaning
83569: FROM xla_events_gt xet
83570: , AR_CUST_TRX_LINES_L_V l2
83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83574: , AR_TRANSACTIONS_S_V l10
83575: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
83576: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

83739:
83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

83740: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_TYPE_NAME%TYPE INDEX BY BINARY_INTEGER;
83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

83741: TYPE t_array_source_4 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
83742: TYPE t_array_source_6 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

83743: TYPE t_array_source_32 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

83744: TYPE t_array_source_33 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

83745: TYPE t_array_source_39 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

83746: TYPE t_array_source_40 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
83747: TYPE t_array_source_41 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
83748: TYPE t_array_source_42 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83749: TYPE t_array_source_43 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
83750: TYPE t_array_source_44 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83751: TYPE t_array_source_45 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83769: TYPE t_array_source_111 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

Line 83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

83762: TYPE t_array_source_104 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
83763: TYPE t_array_source_105 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
83764: TYPE t_array_source_106 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83769: TYPE t_array_source_111 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
83770:

Line 83769: TYPE t_array_source_111 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

83765: TYPE t_array_source_107 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
83766: TYPE t_array_source_108 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
83767: TYPE t_array_source_109 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83768: TYPE t_array_source_110 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83769: TYPE t_array_source_111 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
83770:
83771: l_array_source_16 t_array_source_16;
83772: l_array_source_18 t_array_source_18;
83773: l_array_source_20 t_array_source_20;

Line 83951: , AR_DISTRIBUTIONS_L_V l4

83947: , l4.DIST_SOURCE_TABLE source_111
83948: FROM xla_events_gt xet
83949: , AR_CUST_TRX_LINES_L_V l2
83950: , AR_DISTRIBUTIONS_BASE_V l3
83951: , AR_DISTRIBUTIONS_L_V l4
83952: , AR_RECEIVABLES_TRX_ACT_S_V l7
83953: , AR_TRANSACTIONS_S_V l10
83954: WHERE xet.event_id between x_first_event_id and x_last_event_id
83955: and xet.event_date between p_pad_start_date and p_pad_end_date