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_HEADERS_EXT_V

Line 5877: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

5873: FROM (
5874: SELECT xet.event_id event_id
5875: , 0 line_number
5876: , CASE r
5877: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

5874: SELECT xet.event_id event_id
5875: , 0 line_number
5876: , CASE r
5877: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

5875: , 0 line_number
5876: , CASE r
5877: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

5876: , CASE r
5877: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

5877: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5885: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

5878: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5885: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5886:

Line 5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

5879: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5885: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5886:
5887: ELSE null

Line 5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

5880: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5885: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5886:
5887: ELSE null
5888: END object_name

Line 5885: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

5881: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
5882: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
5883: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
5884: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
5885: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
5886:
5887: ELSE null
5888: END object_name
5889: , CASE r

Line 5949: , LNS_LOAN_HEADERS_EXT_V h2

5945:
5946: ELSE null
5947: END source_meaning
5948: FROM xla_events_gt xet
5949: , LNS_LOAN_HEADERS_EXT_V h2
5950: , fnd_lookup_values fvl1
5951: , fnd_lookup_values fvl15
5952: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5953: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

6260: --
6261: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6262: --
6263:
6264: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

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

6261: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6262: --
6263:
6264: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

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

6262: --
6263:
6264: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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;

Line 6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

6263:
6264: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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;

Line 6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

6264: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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;

Line 6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

6265: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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:

Line 6270: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

6266: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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;

Line 6271: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

6267: TYPE t_array_source_11 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.FUNDS_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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;

Line 6272: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

6268: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
6269: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%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;

Line 6354: , LNS_LOAN_HEADERS_EXT_V h2

6350: , h2.EXCHANGE_RATE source_17
6351: , h2.EXCHANGE_RATE_TYPE source_18
6352: , h2.GL_DATE source_20
6353: FROM xla_events_gt xet
6354: , LNS_LOAN_HEADERS_EXT_V h2
6355: , fnd_lookup_values fvl1
6356: , fnd_lookup_values fvl15
6357: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6358: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 7282: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'

7278: FROM (
7279: SELECT xet.event_id event_id
7280: , 0 line_number
7281: , CASE r
7282: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'

7279: SELECT xet.event_id event_id
7280: , 0 line_number
7281: , CASE r
7282: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'

7280: , 0 line_number
7281: , CASE r
7282: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'

7281: , CASE r
7282: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'

7282: WHEN 1 THEN 'LNS_LOAN_HEADERS_EXT_V'
7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
7290: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

Line 7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'

7283: WHEN 2 THEN 'LNS_LOAN_HEADERS_EXT_V'
7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
7290: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
7291:

Line 7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'

7284: WHEN 3 THEN 'LNS_LOAN_HEADERS_EXT_V'
7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
7290: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
7291:
7292: ELSE null

Line 7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'

7285: WHEN 4 THEN 'LNS_LOAN_HEADERS_EXT_V'
7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
7290: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
7291:
7292: ELSE null
7293: END object_name

Line 7290: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'

7286: WHEN 5 THEN 'LNS_LOAN_HEADERS_EXT_V'
7287: WHEN 6 THEN 'LNS_LOAN_HEADERS_EXT_V'
7288: WHEN 7 THEN 'LNS_LOAN_HEADERS_EXT_V'
7289: WHEN 8 THEN 'LNS_LOAN_HEADERS_EXT_V'
7290: WHEN 9 THEN 'LNS_LOAN_HEADERS_EXT_V'
7291:
7292: ELSE null
7293: END object_name
7294: , CASE r

Line 7354: , LNS_LOAN_HEADERS_EXT_V h2

7350:
7351: ELSE null
7352: END source_meaning
7353: FROM xla_events_gt xet
7354: , LNS_LOAN_HEADERS_EXT_V h2
7355: , fnd_lookup_values fvl1
7356: , fnd_lookup_values fvl15
7357: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
7358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

7660: --
7661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
7662: --
7663:
7664: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

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

7661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
7662: --
7663:
7664: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

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

7662: --
7663:
7664: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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;

Line 7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

7663:
7664: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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;

Line 7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

7664: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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;

Line 7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

7665: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;
7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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:

Line 7670: TYPE t_array_source_18 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

7666: TYPE t_array_source_3 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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;

Line 7671: TYPE t_array_source_19 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.SUBSIDY_COST%TYPE INDEX BY BINARY_INTEGER;

7667: TYPE t_array_source_15 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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;

Line 7672: TYPE t_array_source_20 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

7668: TYPE t_array_source_16 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
7669: TYPE t_array_source_17 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.EXCHANGE_RATE%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;

Line 7752: , LNS_LOAN_HEADERS_EXT_V h2

7748: , h2.EXCHANGE_RATE_TYPE source_18
7749: , h2.SUBSIDY_COST source_19
7750: , h2.GL_DATE source_20
7751: FROM xla_events_gt xet
7752: , LNS_LOAN_HEADERS_EXT_V h2
7753: , fnd_lookup_values fvl1
7754: , fnd_lookup_values fvl15
7755: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
7756: and xet.event_type_code = C_EVENT_TYPE_CODE