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

Line 6029: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'

6025: FROM (
6026: SELECT xet.event_id event_id
6027: , l1.line_number line_number
6028: , CASE r
6029: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'

6026: SELECT xet.event_id event_id
6027: , l1.line_number line_number
6028: , CASE r
6029: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'

6027: , l1.line_number line_number
6028: , CASE r
6029: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'

6028: , CASE r
6029: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

6029: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

6030: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
6038: WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

6031: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
6038: WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V'
6039:

Line 6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

6032: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
6038: WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V'
6039:
6040: ELSE null

Line 6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

6033: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
6038: WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V'
6039:
6040: ELSE null
6041: END object_name

Line 6038: WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V'

6034: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
6035: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
6036: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
6037: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
6038: WHEN 10 THEN 'LNS_LOAN_DETAILS_EXT_V'
6039:
6040: ELSE null
6041: END object_name
6042: , CASE r

Line 6108: , LNS_LOAN_DETAILS_EXT_V l1

6104:
6105: ELSE null
6106: END source_meaning
6107: FROM xla_events_gt xet
6108: , LNS_LOAN_DETAILS_EXT_V l1
6109: , fnd_lookup_values fvl4
6110: , fnd_lookup_values fvl8
6111: , fnd_lookup_values fvl9
6112: , fnd_lookup_values fvl13

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

6270: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
6271: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6272: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6273:
6274: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;

6271: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6272: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6273:
6274: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

6272: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
6273:
6274: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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

6273:
6274: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

6274: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

6275: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6283: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

6276: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6283: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6284:

Line 6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

6277: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6283: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6284:
6285: l_array_source_1 t_array_source_1;

Line 6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

6278: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6283: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6284:
6285: l_array_source_1 t_array_source_1;
6286: l_array_source_1_meaning t_array_lookup_meaning;

Line 6283: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

6279: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
6280: TYPE t_array_source_10 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISBURSEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6281: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
6282: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
6283: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
6284:
6285: l_array_source_1 t_array_source_1;
6286: l_array_source_1_meaning t_array_lookup_meaning;
6287: l_array_source_2 t_array_source_2;

Line 6418: , LNS_LOAN_DETAILS_EXT_V l1

6414: , l1.DISTRIBUTION_TYPE source_13
6415: , fvl13.meaning source_13_meaning
6416: , l1.DISTRIBUTION_AMOUNT source_14
6417: FROM xla_events_gt xet
6418: , LNS_LOAN_DETAILS_EXT_V l1
6419: , fnd_lookup_values fvl4
6420: , fnd_lookup_values fvl8
6421: , fnd_lookup_values fvl9
6422: , fnd_lookup_values fvl13

Line 7434: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'

7430: FROM (
7431: SELECT xet.event_id event_id
7432: , l1.line_number line_number
7433: , CASE r
7434: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'

7431: SELECT xet.event_id event_id
7432: , l1.line_number line_number
7433: , CASE r
7434: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'

7432: , l1.line_number line_number
7433: , CASE r
7434: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'

7433: , CASE r
7434: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'

7434: WHEN 1 THEN 'LNS_LOAN_DETAILS_EXT_V'
7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
7442: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

Line 7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'

7435: WHEN 2 THEN 'LNS_LOAN_DETAILS_EXT_V'
7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
7442: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
7443:

Line 7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'

7436: WHEN 3 THEN 'LNS_LOAN_DETAILS_EXT_V'
7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
7442: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
7443:
7444: ELSE null

Line 7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'

7437: WHEN 4 THEN 'LNS_LOAN_DETAILS_EXT_V'
7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
7442: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
7443:
7444: ELSE null
7445: END object_name

Line 7442: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'

7438: WHEN 5 THEN 'LNS_LOAN_DETAILS_EXT_V'
7439: WHEN 6 THEN 'LNS_LOAN_DETAILS_EXT_V'
7440: WHEN 7 THEN 'LNS_LOAN_DETAILS_EXT_V'
7441: WHEN 8 THEN 'LNS_LOAN_DETAILS_EXT_V'
7442: WHEN 9 THEN 'LNS_LOAN_DETAILS_EXT_V'
7443:
7444: ELSE null
7445: END object_name
7446: , CASE r

Line 7508: , LNS_LOAN_DETAILS_EXT_V l1

7504:
7505: ELSE null
7506: END source_meaning
7507: FROM xla_events_gt xet
7508: , LNS_LOAN_DETAILS_EXT_V l1
7509: , fnd_lookup_values fvl4
7510: , fnd_lookup_values fvl8
7511: , fnd_lookup_values fvl9
7512: , fnd_lookup_values fvl13

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

7670: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7671: TYPE t_array_source_19 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.SUBSIDY_COST%TYPE INDEX BY BINARY_INTEGER;
7672: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
7673:
7674: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;

7671: TYPE t_array_source_19 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.SUBSIDY_COST%TYPE INDEX BY BINARY_INTEGER;
7672: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
7673:
7674: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

7672: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
7673:
7674: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

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

7673:
7674: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;

7674: TYPE t_array_source_4 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
7682: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

7675: TYPE t_array_source_5 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DERIVED_PROGRAM_ACCOUNT_BSV%TYPE INDEX BY BINARY_INTEGER;
7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
7682: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
7683:

Line 7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

7676: TYPE t_array_source_6 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
7682: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
7683:
7684: l_array_source_1 t_array_source_1;

Line 7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

7677: TYPE t_array_source_7 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
7682: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
7683:
7684: l_array_source_1 t_array_source_1;
7685: l_array_source_1_meaning t_array_lookup_meaning;

Line 7682: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

7678: TYPE t_array_source_8 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.ACCOUNT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7679: TYPE t_array_source_9 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.EVENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
7680: TYPE t_array_source_12 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
7681: TYPE t_array_source_13 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
7682: TYPE t_array_source_14 IS TABLE OF LNS_LOAN_DETAILS_EXT_V.DISTRIBUTION_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
7683:
7684: l_array_source_1 t_array_source_1;
7685: l_array_source_1_meaning t_array_lookup_meaning;
7686: l_array_source_2 t_array_source_2;

Line 7815: , LNS_LOAN_DETAILS_EXT_V l1

7811: , l1.DISTRIBUTION_TYPE source_13
7812: , fvl13.meaning source_13_meaning
7813: , l1.DISTRIBUTION_AMOUNT source_14
7814: FROM xla_events_gt xet
7815: , LNS_LOAN_DETAILS_EXT_V l1
7816: , fnd_lookup_values fvl4
7817: , fnd_lookup_values fvl8
7818: , fnd_lookup_values fvl9
7819: , fnd_lookup_values fvl13