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_000004_PKG dependencies on LNS_LOAN_DETAILS_EXT_V

Line 3986: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'

3982: FROM (
3983: SELECT xet.event_id event_id
3984: , l1.line_number line_number
3985: , CASE r
3986: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'

3983: SELECT xet.event_id event_id
3984: , l1.line_number line_number
3985: , CASE r
3986: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'

3984: , l1.line_number line_number
3985: , CASE r
3986: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'

3985: , CASE r
3986: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

3986: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3994: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

3987: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3994: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3995:

Line 3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

3988: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3994: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3995:
3996: ELSE null

Line 3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

3989: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3994: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3995:
3996: ELSE null
3997: END object_name

Line 3994: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

3990: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
3991: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
3992: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
3993: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
3994: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
3995:
3996: ELSE null
3997: END object_name
3998: , CASE r

Line 4060: , LNS_LOAN_DETAILS_EXT_V l1

4056:
4057: ELSE null
4058: END source_meaning
4059: FROM xla_events_gt xet
4060: , LNS_LOAN_DETAILS_EXT_V l1
4061: , fnd_lookup_values fvl4
4062: , fnd_lookup_values fvl6
4063: , fnd_lookup_values fvl8
4064: , fnd_lookup_values fvl12

Line 4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

4222: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

4223: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

4224: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

4225:
4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4233: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

4226: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4233: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4234: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

4227: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4233: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4234: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4235:

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

4228: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4233: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4234: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4235:
4236: l_array_source_1 t_array_source_1;

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

4229: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4233: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4234: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4235:
4236: l_array_source_1 t_array_source_1;
4237: l_array_source_1_meaning t_array_lookup_meaning;

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

4230: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4231: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
4232: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
4233: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
4234: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4235:
4236: l_array_source_1 t_array_source_1;
4237: l_array_source_1_meaning t_array_lookup_meaning;
4238: l_array_source_2 t_array_source_2;

Line 4374: , LNS_LOAN_DETAILS_EXT_V l1

4370: , l1.DISTRIBUTION_TYPE source_12
4371: , fvl12.meaning source_12_meaning
4372: , l1.DISTRIBUTION_AMOUNT source_13
4373: FROM xla_events_gt xet
4374: , LNS_LOAN_DETAILS_EXT_V l1
4375: , fnd_lookup_values fvl4
4376: , fnd_lookup_values fvl6
4377: , fnd_lookup_values fvl8
4378: , fnd_lookup_values fvl12

Line 5324: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'

5320: FROM (
5321: SELECT xet.event_id event_id
5322: , l1.line_number line_number
5323: , CASE r
5324: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'

5321: SELECT xet.event_id event_id
5322: , l1.line_number line_number
5323: , CASE r
5324: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
5329: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'

5322: , l1.line_number line_number
5323: , CASE r
5324: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
5329: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
5330:

Line 5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'

5323: , CASE r
5324: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
5329: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
5330:
5331: ELSE null

Line 5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

5324: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
5329: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
5330:
5331: ELSE null
5332: END object_name

Line 5329: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

5325: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
5326: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
5327: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
5328: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
5329: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
5330:
5331: ELSE null
5332: END object_name
5333: , CASE r

Line 5381: , LNS_LOAN_DETAILS_EXT_V l1

5377:
5378: ELSE null
5379: END source_meaning
5380: FROM xla_events_gt xet
5381: , LNS_LOAN_DETAILS_EXT_V l1
5382: , fnd_lookup_values fvl4
5383: , fnd_lookup_values fvl6
5384: , (select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
5385: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

5533: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5541: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

5534: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5541: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
5542: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

5535: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5541: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
5542: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5543:

Line 5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

5536:
5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5541: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
5542: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5543:
5544: l_array_source_1 t_array_source_1;

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

5537: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5541: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
5542: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5543:
5544: l_array_source_1 t_array_source_1;
5545: l_array_source_1_meaning t_array_lookup_meaning;

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

5538: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
5539: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
5540: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
5541: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
5542: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
5543:
5544: l_array_source_1 t_array_source_1;
5545: l_array_source_1_meaning t_array_lookup_meaning;
5546: l_array_source_2 t_array_source_2;

Line 5671: , LNS_LOAN_DETAILS_EXT_V l1

5667: , l1.LINE_TYPE source_7
5668: , l1.DISTRIBUTION_ID source_11
5669: , l1.DISTRIBUTION_AMOUNT source_13
5670: FROM xla_events_gt xet
5671: , LNS_LOAN_DETAILS_EXT_V l1
5672: , fnd_lookup_values fvl4
5673: , fnd_lookup_values fvl6
5674: WHERE xet.event_id between x_first_event_id and x_last_event_id
5675: and xet.event_date between p_pad_start_date and p_pad_end_date