DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000007_PKG dependencies on AR_CM_LINES_BASE_V

Line 55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'

55839: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

Line 55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'

55840: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'

55841: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

Line 55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'

55842: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'

Line 55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

55843: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'
55851: WHEN 14 THEN 'AR_CM_LINES_L_V'

Line 55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

55844: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'
55851: WHEN 14 THEN 'AR_CM_LINES_L_V'
55852: WHEN 15 THEN 'AR_CM_LINES_L_V'

Line 55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

55845: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55846: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
55847: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
55848: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
55849: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
55850: WHEN 13 THEN 'AR_CM_LINES_L_V'
55851: WHEN 14 THEN 'AR_CM_LINES_L_V'
55852: WHEN 15 THEN 'AR_CM_LINES_L_V'
55853:

Line 55935: , AR_CM_LINES_BASE_V l3

55931: ELSE null
55932: END source_value
55933: , null source_meaning
55934: FROM xla_events_gt xet
55935: , AR_CM_LINES_BASE_V l3
55936: , AR_CM_LINES_L_V l4
55937: , AR_DISTRIBUTIONS_L_V l6
55938: , AR_RECEIVABLES_TRX_ACT_S_V l7
55939: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

Line 56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;

56092: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

56093: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

Line 56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

56094: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

56095: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

56096: TYPE t_array_source_37 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

56097: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
56105: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

56098: TYPE t_array_source_40 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
56099: TYPE t_array_source_41 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
56100: TYPE t_array_source_42 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
56101: TYPE t_array_source_43 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
56102: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
56103: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
56104: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
56105: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
56106:

Line 56231: , AR_CM_LINES_BASE_V l3

56227: , l4.CM_TAX_LINE_ID source_47
56228: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_48
56229: , l4.CM_LINE_DIST_AMT source_49
56230: FROM xla_events_gt xet
56231: , AR_CM_LINES_BASE_V l3
56232: , AR_CM_LINES_L_V l4
56233: , AR_DISTRIBUTIONS_L_V l6
56234: , AR_RECEIVABLES_TRX_ACT_S_V l7
56235: WHERE xet.event_id between x_first_event_id and x_last_event_id