DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG dependencies on AR_CM_LINES_BASE_V

Line 55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

Line 55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'

55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

Line 55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'

Line 55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'
55580: WHEN 14 THEN 'AR_CM_LINES_L_V'

Line 55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'
55580: WHEN 14 THEN 'AR_CM_LINES_L_V'
55581: WHEN 15 THEN 'AR_CM_LINES_L_V'

Line 55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55575: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55576: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55577: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55578: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55579: WHEN 13 THEN 'AR_CM_LINES_L_V'
55580: WHEN 14 THEN 'AR_CM_LINES_L_V'
55581: WHEN 15 THEN 'AR_CM_LINES_L_V'
55582:

Line 55664: , AR_CM_LINES_BASE_V l3

55660: ELSE null
55661: END source_value
55662: , null source_meaning
55663: FROM xla_events_gt xet
55664: , AR_CM_LINES_BASE_V l3
55665: , AR_CM_LINES_L_V l4
55666: , AR_DISTRIBUTIONS_L_V l6
55667: , AR_RECEIVABLES_TRX_ACT_S_V l7
55668: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

Line 55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

Line 55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55834: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55828: TYPE t_array_source_39 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
55829: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
55830: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
55831: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
55832: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
55833: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55834: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
55835:

Line 55960: , AR_CM_LINES_BASE_V l3

55956: , l4.CM_TAX_LINE_ID source_45
55957: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_46
55958: , l4.CM_LINE_DIST_AMT source_47
55959: FROM xla_events_gt xet
55960: , AR_CM_LINES_BASE_V l3
55961: , AR_CM_LINES_L_V l4
55962: , AR_DISTRIBUTIONS_L_V l6
55963: , AR_RECEIVABLES_TRX_ACT_S_V l7
55964: WHERE xet.event_id between x_first_event_id and x_last_event_id