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_000009_PKG dependencies on AR_DISTRIBUTIONS_BASE_V

Line 67846: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'

67842: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
67843: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
67844: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
67845: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
67846: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
67847: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
67848: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
67849: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
67850:

Line 67847: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'

67843: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
67844: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
67845: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
67846: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
67847: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
67848: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
67849: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
67850:
67851: ELSE null

Line 67848: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'

67844: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
67845: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
67846: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
67847: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
67848: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
67849: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
67850:
67851: ELSE null
67852: END object_name

Line 67849: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'

67845: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
67846: WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
67847: WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
67848: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
67849: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
67850:
67851: ELSE null
67852: END object_name
67853: , CASE r

Line 67912: , AR_DISTRIBUTIONS_BASE_V l4

67908: ELSE null
67909: END source_value
67910: , null source_meaning
67911: FROM xla_events_gt xet
67912: , AR_DISTRIBUTIONS_BASE_V l4
67913: , AR_DISTRIBUTIONS_L_V l5
67914: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
67915: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67916: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 68068: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

68064: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
68065: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68066: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68067: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68068: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68069: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68070: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68071: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68072:

Line 68069: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

68065: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68066: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68067: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68068: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68069: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68070: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68071: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68072:
68073: l_array_source_8 t_array_source_8;

Line 68070: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

68066: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
68067: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68068: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68069: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68070: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68071: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68072:
68073: l_array_source_8 t_array_source_8;
68074: l_array_source_23 t_array_source_23;

Line 68071: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

68067: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68068: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68069: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68070: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68071: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68072:
68073: l_array_source_8 t_array_source_8;
68074: l_array_source_23 t_array_source_23;
68075: l_array_source_32 t_array_source_32;

Line 68189: , AR_DISTRIBUTIONS_BASE_V l4

68185: , l4.DIST_CUR_CONVERSION_RATE source_29
68186: , l4.DIST_CUR_CONVERSION_TYPE source_30
68187: , l4.DIST_TO_ACCTD_AMT source_31
68188: FROM xla_events_gt xet
68189: , AR_DISTRIBUTIONS_BASE_V l4
68190: , AR_DISTRIBUTIONS_L_V l5
68191: WHERE xet.event_id between x_first_event_id and x_last_event_id
68192: and xet.event_date between p_pad_start_date and p_pad_end_date
68193: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77635: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'

77631: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
77632: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
77633: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77634: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
77635: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
77636: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
77637: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
77638: WHEN 15 THEN 'FV_XLA_AR_REF_V'
77639: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 77636: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'

77632: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
77633: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77634: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
77635: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
77636: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
77637: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
77638: WHEN 15 THEN 'FV_XLA_AR_REF_V'
77639: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
77640: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'

Line 77637: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'

77633: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
77634: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
77635: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
77636: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
77637: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
77638: WHEN 15 THEN 'FV_XLA_AR_REF_V'
77639: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
77640: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
77641:

Line 77639: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

77635: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
77636: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
77637: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
77638: WHEN 15 THEN 'FV_XLA_AR_REF_V'
77639: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
77640: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
77641:
77642: ELSE null
77643: END object_name

Line 77731: , AR_DISTRIBUTIONS_BASE_V l2

77727: ELSE null
77728: END source_value
77729: , null source_meaning
77730: FROM xla_events_gt xet
77731: , AR_DISTRIBUTIONS_BASE_V l2
77732: , AR_DISTRIBUTIONS_L_V l3
77733: , FV_XLA_AR_REF_V l6
77734: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77895: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

77891: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77892: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77893: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77894: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77895: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77896: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77897: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77898: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77899: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 77896: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

77892: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77893: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77894: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77895: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77896: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77897: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77898: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77899: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77900: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 77897: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

77893: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
77894: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77895: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77896: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77897: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77898: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77899: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77900: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
77901:

Line 77899: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

77895: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77896: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77897: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77898: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77899: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77900: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
77901:
77902: l_array_source_1 t_array_source_1;
77903: l_array_source_3 t_array_source_3;

Line 78032: , AR_DISTRIBUTIONS_BASE_V l2

78028: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
78029: , l2.DIST_TO_CUR_CONVERSION_DATE source_59
78030: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_71
78031: FROM xla_events_gt xet
78032: , AR_DISTRIBUTIONS_BASE_V l2
78033: , AR_DISTRIBUTIONS_L_V l3
78034: , FV_XLA_AR_REF_V l6
78035: WHERE xet.event_id between x_first_event_id and x_last_event_id
78036: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 79529: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'

79525: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
79526: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
79527: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
79528: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
79529: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'

Line 79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'

79526: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
79527: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
79528: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
79529: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'

Line 79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'

79527: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
79528: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
79529: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'

Line 79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'

79528: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
79529: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'

Line 79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'

79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'
79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
79539: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
79540: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79541: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 79541: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'

79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
79539: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
79540: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
79541: WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
79542: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
79543: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
79544: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
79545: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79547: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'

79543: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
79544: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
79545: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
79546: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
79547: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
79548: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'
79549: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
79550:
79551: ELSE null

Line 79548: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'

79544: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
79545: WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
79546: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
79547: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
79548: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'
79549: WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
79550:
79551: ELSE null
79552: END object_name

Line 79714: , AR_DISTRIBUTIONS_BASE_V l4

79710: , null source_meaning
79711: FROM xla_events_gt xet
79712: , AR_BILL_TO_CUSTOMERS_S_V l1
79713: , AR_CUST_TRX_LINES_L_V l3
79714: , AR_DISTRIBUTIONS_BASE_V l4
79715: , AR_DISTRIBUTIONS_L_V l5
79716: , AR_RECEIVABLES_TRX_ACT_S_V l8
79717: , AR_TRANSACTIONS_S_V l11
79718: , FV_XLA_AR_REF_V l12

Line 79900: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

79896: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79897: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79898: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79899: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79900: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

79897: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79898: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79899: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79900: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79898: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
79899: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79900: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

79899: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79900: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79910: TYPE t_array_source_62 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79911: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79912: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 79912: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79910: TYPE t_array_source_62 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79911: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
79912: TYPE t_array_source_64 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79913: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
79914: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79915: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79916: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;

Line 79918: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

79914: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
79915: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79916: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79917: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79918: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79919: TYPE t_array_source_76 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79920: TYPE t_array_source_77 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79921:
79922: l_array_source_1 t_array_source_1;

Line 79919: TYPE t_array_source_76 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79915: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79916: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79917: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;
79918: TYPE t_array_source_75 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79919: TYPE t_array_source_76 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79920: TYPE t_array_source_77 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
79921:
79922: l_array_source_1 t_array_source_1;
79923: l_array_source_3 t_array_source_3;

Line 80112: , AR_DISTRIBUTIONS_BASE_V l4

80108: , l5.DIST_SOURCE_TABLE source_77
80109: FROM xla_events_gt xet
80110: , AR_BILL_TO_CUSTOMERS_S_V l1
80111: , AR_CUST_TRX_LINES_L_V l3
80112: , AR_DISTRIBUTIONS_BASE_V l4
80113: , AR_DISTRIBUTIONS_L_V l5
80114: , AR_RECEIVABLES_TRX_ACT_S_V l8
80115: , AR_TRANSACTIONS_S_V l11
80116: , FV_XLA_AR_REF_V l12