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_DETAILS_EXT_V

Line 3038: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'

3034: FROM (
3035: SELECT xet.event_id event_id
3036: , l1.line_number line_number
3037: , CASE r
3038: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'

3035: SELECT xet.event_id event_id
3036: , l1.line_number line_number
3037: , CASE r
3038: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'

3036: , l1.line_number line_number
3037: , CASE r
3038: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'

3037: , CASE r
3038: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

3038: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3046: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

3039: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3046: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3047:

Line 3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

3040: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3046: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3047:
3048: ELSE null

Line 3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

3041: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3046: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3047:
3048: ELSE null
3049: END object_name

Line 3046: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

3042: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3043: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3044: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3045: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3046: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3047:
3048: ELSE null
3049: END object_name
3050: , CASE r

Line 3112: , LNS_LOAN_DETAILS_EXT_V l1

3108:
3109: ELSE null
3110: END source_meaning
3111: FROM xla_events_gt xet
3112: , LNS_LOAN_DETAILS_EXT_V l1
3113: , fnd_lookup_values fvl4
3114: , fnd_lookup_values fvl6
3115: , fnd_lookup_values fvl8
3116: , fnd_lookup_values fvl12

Line 3278: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3279: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 3280: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3286: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3286: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3287:

Line 3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_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;
3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3286: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3287:
3288: l_array_source_1 t_array_source_1;

Line 3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

3281: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3286: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3287:
3288: l_array_source_1 t_array_source_1;
3289: l_array_source_1_meaning t_array_lookup_meaning;

Line 3286: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

3282: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
3283: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
3284: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
3285: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3286: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
3287:
3288: l_array_source_1 t_array_source_1;
3289: l_array_source_1_meaning t_array_lookup_meaning;
3290: l_array_source_2 t_array_source_2;

Line 3425: , LNS_LOAN_DETAILS_EXT_V l1

3421: , l1.DISTRIBUTION_TYPE source_12
3422: , fvl12.meaning source_12_meaning
3423: , l1.DISTRIBUTION_AMOUNT source_13
3424: FROM xla_events_gt xet
3425: , LNS_LOAN_DETAILS_EXT_V l1
3426: , fnd_lookup_values fvl4
3427: , fnd_lookup_values fvl6
3428: , fnd_lookup_values fvl8
3429: , fnd_lookup_values fvl12

Line 4375: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'

4371: FROM (
4372: SELECT xet.event_id event_id
4373: , l1.line_number line_number
4374: , CASE r
4375: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'

4372: SELECT xet.event_id event_id
4373: , l1.line_number line_number
4374: , CASE r
4375: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
4380: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'

4373: , l1.line_number line_number
4374: , CASE r
4375: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
4380: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
4381:

Line 4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'

4374: , CASE r
4375: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
4380: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
4381:
4382: ELSE null

Line 4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

4375: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
4380: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
4381:
4382: ELSE null
4383: END object_name

Line 4380: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

4376: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
4377: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
4378: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
4379: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
4380: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
4381:
4382: ELSE null
4383: END object_name
4384: , CASE r

Line 4432: , LNS_LOAN_DETAILS_EXT_V l1

4428:
4429: ELSE null
4430: END source_meaning
4431: FROM xla_events_gt xet
4432: , LNS_LOAN_DETAILS_EXT_V l1
4433: , fnd_lookup_values fvl4
4434: , fnd_lookup_values fvl6
4435: , (select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
4436: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 4588: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%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;
4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 4589: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%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;
4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4593: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 4590: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_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;
4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4593: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4594:

Line 4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%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;
4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4593: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4594:
4595: l_array_source_1 t_array_source_1;

Line 4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

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;
4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4593: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4594:
4595: l_array_source_1 t_array_source_1;
4596: l_array_source_1_meaning t_array_lookup_meaning;

Line 4593: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%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;
4591: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4592: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4593: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4594:
4595: l_array_source_1 t_array_source_1;
4596: l_array_source_1_meaning t_array_lookup_meaning;
4597: l_array_source_2 t_array_source_2;

Line 4722: , LNS_LOAN_DETAILS_EXT_V l1

4718: , l1.LINE_TYPE source_7
4719: , l1.DISTRIBUTION_ID source_11
4720: , l1.DISTRIBUTION_AMOUNT source_13
4721: FROM xla_events_gt xet
4722: , LNS_LOAN_DETAILS_EXT_V l1
4723: , fnd_lookup_values fvl4
4724: , fnd_lookup_values fvl6
4725: WHERE xet.event_id between x_first_event_id and x_last_event_id
4726: and xet.event_date between p_pad_start_date and p_pad_end_date