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_000006_PKG dependencies on AR_DISTRIBUTIONS_L_V

Line 69050: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

69046: FROM (
69047: SELECT xet.event_id event_id
69048: , l5.line_number line_number
69049: , CASE r
69050: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

Line 69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

69047: SELECT xet.event_id event_id
69048: , l5.line_number line_number
69049: , CASE r
69050: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69055: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

69048: , l5.line_number line_number
69049: , CASE r
69050: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69055: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69056: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

69049: , CASE r
69050: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69055: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69056: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
69057: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

69050: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69055: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69056: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
69057: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
69058: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 69055: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

69051: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
69052: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
69053: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
69054: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
69055: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
69056: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
69057: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
69058: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
69059: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 69123: , AR_DISTRIBUTIONS_L_V l5

69119: END source_value
69120: , null source_meaning
69121: FROM xla_events_gt xet
69122: , AR_DISTRIBUTIONS_BASE_V l4
69123: , AR_DISTRIBUTIONS_L_V l5
69124: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
69125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69126: AND xet.event_class_code = C_EVENT_CLASS_CODE
69127: AND l4.event_id = xet.event_id

Line 69272: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

69268: TYPE t_array_source_79 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69269: TYPE t_array_source_80 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69270: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69271:
69272: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

69269: TYPE t_array_source_80 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69270: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69271:
69272: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69277: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

69270: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69271:
69272: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69277: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69278: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

69271:
69272: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69277: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69278: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69279: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

69272: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69277: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69278: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69279: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69280: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69277: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

69273: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
69274: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
69275: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69276: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
69277: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69278: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69279: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69280: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69281: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69400: , AR_DISTRIBUTIONS_L_V l5

69396: , l4.DIST_CUR_CONVERSION_TYPE source_28
69397: , l4.DIST_TO_ACCTD_AMT source_29
69398: FROM xla_events_gt xet
69399: , AR_DISTRIBUTIONS_BASE_V l4
69400: , AR_DISTRIBUTIONS_L_V l5
69401: WHERE xet.event_id between x_first_event_id and x_last_event_id
69402: and xet.event_date between p_pad_start_date and p_pad_end_date
69403: and xet.event_class_code = C_EVENT_CLASS_CODE
69404: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

Line 71696: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

71692: SELECT xet.event_id event_id
71693: , l3.line_number line_number
71694: , CASE r
71695: WHEN 1 THEN 'AR_CM_LINES_L_V'
71696: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

Line 71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

71693: , l3.line_number line_number
71694: , CASE r
71695: WHEN 1 THEN 'AR_CM_LINES_L_V'
71696: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

Line 71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

71695: WHEN 1 THEN 'AR_CM_LINES_L_V'
71696: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

Line 71794: , AR_DISTRIBUTIONS_L_V l6

71790: , null source_meaning
71791: FROM xla_events_gt xet
71792: , AR_CM_LINES_BASE_V l3
71793: , AR_CM_LINES_L_V l4
71794: , AR_DISTRIBUTIONS_L_V l6
71795: , AR_RECEIVABLES_TRX_ACT_S_V l7
71796: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
71797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71798: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

71945: TYPE t_array_source_51 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
71947:
71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

Line 71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

71946: TYPE t_array_source_67 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
71947:
71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

71948: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71949: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 72090: , AR_DISTRIBUTIONS_L_V l6

72086: , l4.CM_LINE_DIST_AMT source_54
72087: FROM xla_events_gt xet
72088: , AR_CM_LINES_BASE_V l3
72089: , AR_CM_LINES_L_V l4
72090: , AR_DISTRIBUTIONS_L_V l6
72091: , AR_RECEIVABLES_TRX_ACT_S_V l7
72092: WHERE xet.event_id between x_first_event_id and x_last_event_id
72093: and xet.event_date between p_pad_start_date and p_pad_end_date
72094: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78867: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

78863: FROM (
78864: SELECT xet.event_id event_id
78865: , l3.line_number line_number
78866: , CASE r
78867: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'
78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'

Line 78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
78878: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
78878: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
78879: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
78878: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
78879: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
78880: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
78878: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
78879: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
78880: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
78881: WHEN 15 THEN 'FV_XLA_AR_REF_V'

Line 78883: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'

78879: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
78880: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
78881: WHEN 15 THEN 'FV_XLA_AR_REF_V'
78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
78883: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78884:
78885: ELSE null
78886: END object_name
78887: , CASE r

Line 78975: , AR_DISTRIBUTIONS_L_V l3

78971: END source_value
78972: , null source_meaning
78973: FROM xla_events_gt xet
78974: , AR_DISTRIBUTIONS_BASE_V l2
78975: , AR_DISTRIBUTIONS_L_V l3
78976: , FV_XLA_AR_REF_V l6
78977: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
78978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78979: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

79123: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

Line 79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79138: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79138: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79139: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79138: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79139: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79140: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79138: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79139: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79140: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79141: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79143: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

79139: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79140: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79141: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79142: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79143: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79144:
79145: l_array_source_1 t_array_source_1;
79146: l_array_source_13 t_array_source_13;
79147: l_array_source_14 t_array_source_14;

Line 79276: , AR_DISTRIBUTIONS_L_V l3

79272: , l2.DIST_TO_CUR_CONVERSION_DATE source_57
79273: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_69
79274: FROM xla_events_gt xet
79275: , AR_DISTRIBUTIONS_BASE_V l2
79276: , AR_DISTRIBUTIONS_L_V l3
79277: , FV_XLA_AR_REF_V l6
79278: WHERE xet.event_id between x_first_event_id and x_last_event_id
79279: and xet.event_date between p_pad_start_date and p_pad_end_date
79280: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 80756: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

80752: FROM (
80753: SELECT xet.event_id event_id
80754: , l5.line_number line_number
80755: , CASE r
80756: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'

Line 80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
80769: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
80770: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'

80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
80769: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
80770: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
80771: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'

80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
80769: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
80770: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
80771: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
80772: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80769: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'

80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
80768: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
80769: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
80770: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
80771: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
80772: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
80773: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'

80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'
80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'

80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'

80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
80788: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'

80781: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
80788: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
80789: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'

80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
80788: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
80789: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'
80790: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'

80783: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
80784: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
80785: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
80788: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
80789: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'
80790: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
80791:

Line 80790: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'

80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
80787: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
80788: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
80789: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'
80790: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
80791:
80792: ELSE null
80793: END object_name
80794: , CASE r

Line 80956: , AR_DISTRIBUTIONS_L_V l5

80952: FROM xla_events_gt xet
80953: , AR_BILL_TO_CUSTOMERS_S_V l1
80954: , AR_CUST_TRX_LINES_L_V l3
80955: , AR_DISTRIBUTIONS_BASE_V l4
80956: , AR_DISTRIBUTIONS_L_V l5
80957: , AR_RECEIVABLES_TRX_ACT_S_V l8
80958: , AR_TRANSACTIONS_S_V l11
80959: , FV_XLA_AR_REF_V l12
80960: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

Line 81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

81121: TYPE t_array_source_87 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
81138: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
81139: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
81138: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
81139: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81140: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
81138: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
81139: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81140: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81141: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81138: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81137: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
81138: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
81139: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81140: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81141: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81142: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81148: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
81149: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

81148: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
81149: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

81149: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
81157: TYPE t_array_source_73 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

81150: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
81157: TYPE t_array_source_73 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81158: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
81157: TYPE t_array_source_73 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81158: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81159: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

Line 81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

81152: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
81153: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
81154: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
81157: TYPE t_array_source_73 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81158: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81159: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
81160:

Line 81159: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;

81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
81156: TYPE t_array_source_72 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
81157: TYPE t_array_source_73 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81158: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81159: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
81160:
81161: l_array_source_1 t_array_source_1;
81162: l_array_source_13 t_array_source_13;
81163: l_array_source_14 t_array_source_14;

Line 81348: , AR_DISTRIBUTIONS_L_V l5

81344: FROM xla_events_gt xet
81345: , AR_BILL_TO_CUSTOMERS_S_V l1
81346: , AR_CUST_TRX_LINES_L_V l3
81347: , AR_DISTRIBUTIONS_BASE_V l4
81348: , AR_DISTRIBUTIONS_L_V l5
81349: , AR_RECEIVABLES_TRX_ACT_S_V l8
81350: , AR_TRANSACTIONS_S_V l11
81351: , FV_XLA_AR_REF_V l12
81352: WHERE xet.event_id between x_first_event_id and x_last_event_id