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_CM_LINES_BASE_V

Line 70459: WHEN 6 THEN 'AR_CM_LINES_BASE_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'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'

Line 70460: WHEN 7 THEN 'AR_CM_LINES_BASE_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'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'

Line 70461: WHEN 8 THEN 'AR_CM_LINES_BASE_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'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

Line 70462: WHEN 9 THEN 'AR_CM_LINES_BASE_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'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'

Line 70463: WHEN 10 THEN 'AR_CM_LINES_BASE_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'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'
70467: WHEN 14 THEN 'AR_CM_LINES_L_V'

Line 70464: WHEN 11 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'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'
70467: WHEN 14 THEN 'AR_CM_LINES_L_V'
70468: WHEN 15 THEN 'AR_CM_LINES_L_V'

Line 70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'

70461: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
70462: WHEN 9 THEN 'AR_CM_LINES_BASE_V'
70463: WHEN 10 THEN 'AR_CM_LINES_BASE_V'
70464: WHEN 11 THEN 'AR_CM_LINES_BASE_V'
70465: WHEN 12 THEN 'AR_CM_LINES_BASE_V'
70466: WHEN 13 THEN 'AR_CM_LINES_L_V'
70467: WHEN 14 THEN 'AR_CM_LINES_L_V'
70468: WHEN 15 THEN 'AR_CM_LINES_L_V'
70469:

Line 70551: , AR_CM_LINES_BASE_V l3

70547: ELSE null
70548: END source_value
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)

Line 70712: TYPE t_array_source_44 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 70713: TYPE t_array_source_45 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;

Line 70714: TYPE t_array_source_47 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 70715: TYPE t_array_source_48 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_RATE%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70721: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%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;
70716: TYPE t_array_source_49 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70717: TYPE t_array_source_50 IS TABLE OF AR_CM_LINES_BASE_V.GAIN_LOSS_REF%TYPE INDEX BY BINARY_INTEGER;
70718: TYPE t_array_source_51 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
70719: TYPE t_array_source_54 IS TABLE OF AR_CM_LINES_L_V.CM_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
70720: TYPE t_array_source_55 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70721: TYPE t_array_source_56 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70722:

Line 70847: , AR_CM_LINES_BASE_V l3

70843: , l4.CM_TAX_LINE_ID source_54
70844: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_55
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