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_L_V

Line 67840: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

67836: FROM (
67837: SELECT xet.event_id event_id
67838: , l5.line_number line_number
67839: , CASE r
67840: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

67837: SELECT xet.event_id event_id
67838: , l5.line_number line_number
67839: , CASE r
67840: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 67842: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

67838: , l5.line_number line_number
67839: , CASE r
67840: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 67843: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'

67839: , CASE r
67840: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 67844: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

67840: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 67845: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

67841: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_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'

Line 67913: , AR_DISTRIBUTIONS_L_V l5

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
67917: AND l4.event_id = xet.event_id

Line 68062: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

68058: TYPE t_array_source_81 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68059: TYPE t_array_source_82 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68060: TYPE t_array_source_83 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68061:
68062: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

68059: TYPE t_array_source_82 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68060: TYPE t_array_source_83 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68061:
68062: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 68064: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

68060: TYPE t_array_source_83 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
68061:
68062: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 68065: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

68061:
68062: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 68066: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

68062: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 68067: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

68063: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 68190: , AR_DISTRIBUTIONS_L_V l5

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
68194: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id

Line 70455: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'

70451: SELECT xet.event_id event_id
70452: , l3.line_number line_number
70453: , CASE r
70454: WHEN 1 THEN 'AR_CM_LINES_L_V'
70455: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
70456: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
70457: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
70458: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
70459: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

Line 70456: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'

70452: , l3.line_number line_number
70453: , CASE r
70454: WHEN 1 THEN 'AR_CM_LINES_L_V'
70455: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
70456: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
70457: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
70458: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
70459: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
70460: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

Line 70458: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'

70454: WHEN 1 THEN 'AR_CM_LINES_L_V'
70455: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
70456: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
70457: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
70458: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
70459: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
70460: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
70461: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
70462: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

Line 70553: , AR_DISTRIBUTIONS_L_V l6

70549: , null source_meaning
70550: FROM xla_events_gt xet
70551: , AR_CM_LINES_BASE_V l3
70552: , AR_CM_LINES_L_V l4
70553: , AR_DISTRIBUTIONS_L_V l6
70554: , AR_RECEIVABLES_TRX_ACT_S_V l7
70555: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
70556: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70557: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

70704: TYPE t_array_source_53 IS TABLE OF AR_CM_BILL_SITE_USES_H_V.CM_BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
70706:
70707: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70710: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
70711: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
70712: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

Line 70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

70705: TYPE t_array_source_69 IS TABLE OF AR_CREDIT_MEMO_H_V.CM_INVOICING_RULE_ID%TYPE INDEX BY BINARY_INTEGER;
70706:
70707: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70710: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
70711: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
70712: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
70713: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 70711: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

70707: TYPE t_array_source_9 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70708: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
70709: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70710: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
70711: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
70712: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
70713: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
70714: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70715: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 70849: , AR_DISTRIBUTIONS_L_V l6

70845: , l4.CM_LINE_DIST_AMT source_56
70846: FROM xla_events_gt xet
70847: , AR_CM_LINES_BASE_V l3
70848: , AR_CM_LINES_L_V l4
70849: , AR_DISTRIBUTIONS_L_V l6
70850: , AR_RECEIVABLES_TRX_ACT_S_V l7
70851: WHERE xet.event_id between x_first_event_id and x_last_event_id
70852: and xet.event_date between p_pad_start_date and p_pad_end_date
70853: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 77624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

77620: FROM (
77621: SELECT xet.event_id event_id
77622: , l3.line_number line_number
77623: , CASE r
77624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'

Line 77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77631: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77632: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77633: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77634: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_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'

Line 77640: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_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
77644: , CASE r

Line 77732: , AR_DISTRIBUTIONS_L_V l3

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
77736: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

77880: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

Line 77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 77891: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 77892: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 77893: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 77894: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%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;

Line 77900: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;
77904: l_array_source_5 t_array_source_5;

Line 78033: , AR_DISTRIBUTIONS_L_V l3

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
78037: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79515: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'

79511: FROM (
79512: SELECT xet.event_id event_id
79513: , l5.line_number line_number
79514: , CASE r
79515: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
79517: WHEN 3 THEN 'FV_XLA_AR_REF_V'
79518: WHEN 4 THEN 'FV_XLA_AR_REF_V'
79519: WHEN 5 THEN 'FV_XLA_AR_REF_V'

Line 79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

79519: WHEN 5 THEN 'FV_XLA_AR_REF_V'
79520: WHEN 6 THEN 'FV_XLA_AR_REF_V'
79521: WHEN 7 THEN 'FV_XLA_AR_REF_V'
79522: WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'
79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79525: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

79521: WHEN 7 THEN 'FV_XLA_AR_REF_V'
79522: WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'
79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79526: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'

79522: WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'
79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79527: WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'

79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79528: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'

79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_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'

Line 79540: WHEN 26 THEN 'AR_DISTRIBUTIONS_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'
79542: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
79543: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
79544: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79542: WHEN 28 THEN 'AR_DISTRIBUTIONS_L_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'
79546: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79543: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_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'
79546: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
79547: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 79544: WHEN 30 THEN 'AR_DISTRIBUTIONS_L_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'
79546: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
79547: WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
79548: WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 79545: WHEN 31 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'
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'

Line 79546: WHEN 32 THEN 'AR_DISTRIBUTIONS_L_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'
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:

Line 79549: WHEN 35 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
79553: , CASE r

Line 79715: , AR_DISTRIBUTIONS_L_V l5

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
79719: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)

Line 79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

79882: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79883: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79889: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79890: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

79890: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79891: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79892: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79893: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79896: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

79892: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79893: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79897: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79893: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79898: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79899: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%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;

Line 79911: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%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;
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;

Line 79913: TYPE t_array_source_65 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_ID%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;
79917: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 79914: TYPE t_array_source_66 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_SITE_ID%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;
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;

Line 79915: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_PARTY_TYPE%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;
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;

Line 79916: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%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;
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;

Line 79917: TYPE t_array_source_74 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT_FROM%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;
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:

Line 79920: TYPE t_array_source_77 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TABLE%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;
79924: l_array_source_4 t_array_source_4;

Line 80113: , AR_DISTRIBUTIONS_L_V l5

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
80117: WHERE xet.event_id between x_first_event_id and x_last_event_id