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_00206_AAD_S_000003_PKG dependencies on LNS_LOAN_HEADERS_EXT_V

Line 2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

2875: FROM (
2876: SELECT xet.event_id event_id
2877: , 0 line_number
2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

2876: SELECT xet.event_id event_id
2877: , 0 line_number
2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

2877: , 0 line_number
2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

2878: , CASE r
2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

2879: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
2887: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

2880: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
2887: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
2888:

Line 2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

2881: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
2887: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
2888:
2889: ELSE null

Line 2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

2882: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
2887: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
2888:
2889: ELSE null
2890: END object_name

Line 2887: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

2883: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
2884: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
2885: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
2886: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
2887: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
2888:
2889: ELSE null
2890: END object_name
2891: , CASE r

Line 2952: , LNS_LOAN_HEADERS_EXT_V h2

2948:
2949: ELSE null
2950: END source_meaning
2951: FROM xla_events_gt xet
2952: , LNS_LOAN_HEADERS_EXT_V h2
2953: , fnd_lookup_values fvl1
2954: , fnd_lookup_values fvl10
2955: , fnd_lookup_values fvl14
2956: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

Line 3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

3264: --
3265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3266: --
3267:
3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

3265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3266: --
3267:
3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

3266: --
3267:
3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;

3267:
3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3277:

Line 3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

3270: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3277:
3278: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

3271: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3277:
3278: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
3279: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 3276: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

3272: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
3277:
3278: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
3279: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
3280: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3357: , LNS_LOAN_HEADERS_EXT_V h2

3353: , h2.EXCHANGE_RATE source_16
3354: , h2.EXCHANGE_RATE_TYPE source_17
3355: , h2.GL_DATE source_18
3356: FROM xla_events_gt xet
3357: , LNS_LOAN_HEADERS_EXT_V h2
3358: , fnd_lookup_values fvl1
3359: , fnd_lookup_values fvl10
3360: , fnd_lookup_values fvl14
3361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 4216: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

4212: FROM (
4213: SELECT xet.event_id event_id
4214: , 0 line_number
4215: , CASE r
4216: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

4213: SELECT xet.event_id event_id
4214: , 0 line_number
4215: , CASE r
4216: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

4214: , 0 line_number
4215: , CASE r
4216: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

4215: , CASE r
4216: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

4216: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
4224: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

4217: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
4224: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
4225:

Line 4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

4218: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
4224: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
4225:
4226: ELSE null

Line 4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

4219: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
4224: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
4225:
4226: ELSE null
4227: END object_name

Line 4224: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

4220: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
4221: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
4222: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
4223: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
4224: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
4225:
4226: ELSE null
4227: END object_name
4228: , CASE r

Line 4289: , LNS_LOAN_HEADERS_EXT_V h2

4285:
4286: ELSE null
4287: END source_meaning
4288: FROM xla_events_gt xet
4289: , LNS_LOAN_HEADERS_EXT_V h2
4290: , fnd_lookup_values fvl1
4291: , fnd_lookup_values fvl10
4292: , fnd_lookup_values fvl14
4293: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

Line 4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

4574: --
4575: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4576: --
4577:
4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

4575: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4576: --
4577:
4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

4576: --
4577:
4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;

4577:
4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4586: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4586: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4587:

Line 4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

4580: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4586: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4587:
4588: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

4581: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_STATUS%TYPE INDEX BY BINARY_INTEGER;
4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4586: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4587:
4588: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4589: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 4586: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

4582: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
4583: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
4584: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4585: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4586: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4587:
4588: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4589: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4590: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4659: , LNS_LOAN_HEADERS_EXT_V h2

4655: , h2.EXCHANGE_RATE source_16
4656: , h2.EXCHANGE_RATE_TYPE source_17
4657: , h2.GL_DATE source_18
4658: FROM xla_events_gt xet
4659: , LNS_LOAN_HEADERS_EXT_V h2
4660: , fnd_lookup_values fvl1
4661: , fnd_lookup_values fvl10
4662: , fnd_lookup_values fvl14
4663: WHERE xet.event_date between p_pad_start_date and p_pad_end_date