DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000006_PKG dependencies on AR_CM_LINES_BASE_V

Line 71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

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

Line 71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

71697: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'

71698: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

Line 71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

71699: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'

Line 71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

71700: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'
71708: WHEN 14 THEN 'AR_CM_LINES_L_V'

Line 71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

71701: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'
71708: WHEN 14 THEN 'AR_CM_LINES_L_V'
71709: WHEN 15 THEN 'AR_CM_LINES_L_V'

Line 71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

71702: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
71703: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
71704: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
71705: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
71706: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
71707: WHEN 13 THEN 'AR_CM_LINES_L_V'
71708: WHEN 14 THEN 'AR_CM_LINES_L_V'
71709: WHEN 15 THEN 'AR_CM_LINES_L_V'
71710:

Line 71792: , AR_CM_LINES_BASE_V l3

71788: ELSE null
71789: END source_value
71790: , null source_meaning
71791: FROM xla_events_gt xet
71792: , AR_CM_LINES_BASE_V l3
71793: , AR_CM_LINES_L_V l4
71794: , AR_DISTRIBUTIONS_L_V l6
71795: , AR_RECEIVABLES_TRX_ACT_S_V l7
71796: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

Line 71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

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

Line 71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

71950: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

Line 71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

71951: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

71952: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

71953: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71961: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

71954: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71961: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71962: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

71955: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71956: TYPE t_array_source_46 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71957: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71958: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
71959: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71960: TYPE t_array_source_52 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71961: TYPE t_array_source_53 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71962: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71963:

Line 72088: , AR_CM_LINES_BASE_V l3

72084: , l4.CM_TAX_LINE_ID source_52
72085: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
72086: , l4.CM_LINE_DIST_AMT source_54
72087: FROM xla_events_gt xet
72088: , AR_CM_LINES_BASE_V l3
72089: , AR_CM_LINES_L_V l4
72090: , AR_DISTRIBUTIONS_L_V l6
72091: , AR_RECEIVABLES_TRX_ACT_S_V l7
72092: WHERE xet.event_id between x_first_event_id and x_last_event_id