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_BASE_V

Line 69056: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_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'
69060:

Line 69057: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_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'
69060:
69061: ELSE null

Line 69058: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_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'
69060:
69061: ELSE null
69062: END object_name

Line 69059: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_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'
69060:
69061: ELSE null
69062: END object_name
69063: , CASE r

Line 69122: , AR_DISTRIBUTIONS_BASE_V l4

69118: ELSE null
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

Line 69278: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%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;
69282:

Line 69279: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%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;
69282:
69283: l_array_source_16 t_array_source_16;

Line 69280: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_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;
69282:
69283: l_array_source_16 t_array_source_16;
69284: l_array_source_21 t_array_source_21;

Line 69281: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_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;
69282:
69283: l_array_source_16 t_array_source_16;
69284: l_array_source_21 t_array_source_21;
69285: l_array_source_30 t_array_source_30;

Line 69399: , AR_DISTRIBUTIONS_BASE_V l4

69395: , l4.DIST_CUR_CONVERSION_RATE source_27
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

Line 78878: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_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'
78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78879: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_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'
78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
78883: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78880: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_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'
78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
78883: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78884:

Line 78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_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'
78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
78883: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78884:
78885: ELSE null
78886: END object_name

Line 78974: , AR_DISTRIBUTIONS_BASE_V l2

78970: ELSE null
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

Line 79138: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%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;
79142: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 79139: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%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;
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;

Line 79140: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%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;
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:

Line 79142: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%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;
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;

Line 79275: , AR_DISTRIBUTIONS_BASE_V l2

79271: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
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

Line 80770: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_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'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'

Line 80771: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_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'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'

Line 80772: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_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'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'

Line 80773: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_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'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'

Line 80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'

80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_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'

Line 80782: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_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'
80786: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80788: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_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:
80792: ELSE null

Line 80789: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_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:
80792: ELSE null
80793: END object_name

Line 80955: , AR_DISTRIBUTIONS_BASE_V l4

80951: , null source_meaning
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

Line 81139: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%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;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 81140: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%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;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81141: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_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;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81142: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_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;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%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;

Line 81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%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;

Line 81151: TYPE t_array_source_62 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%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;
81155: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 81157: TYPE t_array_source_73 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%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:
81161: l_array_source_1 t_array_source_1;

Line 81158: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%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:
81161: l_array_source_1 t_array_source_1;
81162: l_array_source_13 t_array_source_13;

Line 81347: , AR_DISTRIBUTIONS_BASE_V l4

81343: , l5.DIST_SOURCE_TABLE source_75
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