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 FND_LOOKUP_VALUES

Line 2926: , fnd_lookup_values fvl1

2922: ELSE null
2923: END source_meaning
2924: FROM xla_events_gt xet
2925: , LNS_LOAN_HEADERS_EXT_V h1
2926: , fnd_lookup_values fvl1
2927: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
2928: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2929: AND xet.event_type_code = C_EVENT_TYPE_CODE
2930: AND h1.event_id = xet.event_id

Line 3065: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

3061: l_balance_type_code VARCHAR2(1) :=NULL;
3062: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
3063:
3064: --
3065: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3066: --
3067:
3068: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3069: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3118: , fnd_lookup_values fvl1

3114: , h1.LOAN_NUMBER source_3
3115: , h1.GL_DATE source_18
3116: FROM xla_events_gt xet
3117: , LNS_LOAN_HEADERS_EXT_V h1
3118: , fnd_lookup_values fvl1
3119: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3120: and xet.event_type_code = C_EVENT_TYPE_CODE
3121: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
3122: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 3902: , fnd_lookup_values fvl1

3898: ELSE null
3899: END source_meaning
3900: FROM xla_events_gt xet
3901: , LNS_LOAN_HEADERS_EXT_V h2
3902: , fnd_lookup_values fvl1
3903: , fnd_lookup_values fvl10
3904: , fnd_lookup_values fvl14
3905: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
3906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 3903: , fnd_lookup_values fvl10

3899: END source_meaning
3900: FROM xla_events_gt xet
3901: , LNS_LOAN_HEADERS_EXT_V h2
3902: , fnd_lookup_values fvl1
3903: , fnd_lookup_values fvl10
3904: , fnd_lookup_values fvl14
3905: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
3906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3907: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 3904: , fnd_lookup_values fvl14

3900: FROM xla_events_gt xet
3901: , LNS_LOAN_HEADERS_EXT_V h2
3902: , fnd_lookup_values fvl1
3903: , fnd_lookup_values fvl10
3904: , fnd_lookup_values fvl14
3905: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
3906: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3907: AND xet.event_type_code = C_EVENT_TYPE_CODE
3908: AND h2.event_id = xet.event_id

Line 4061: , fnd_lookup_values fvl4

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
4065: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)

Line 4062: , fnd_lookup_values fvl6

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
4065: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 4063: , fnd_lookup_values fvl8

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
4065: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4067: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 4064: , fnd_lookup_values fvl12

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
4065: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4066: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4067: AND xet.event_type_code = C_EVENT_TYPE_CODE
4068: AND l1.event_id = xet.event_id

Line 4213: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

4209: l_balance_type_code VARCHAR2(1) :=NULL;
4210: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
4211:
4212: --
4213: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4214: --
4215:
4216: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4217: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4307: , fnd_lookup_values fvl1

4303: , h2.EXCHANGE_RATE_TYPE source_17
4304: , h2.GL_DATE source_18
4305: FROM xla_events_gt xet
4306: , LNS_LOAN_HEADERS_EXT_V h2
4307: , fnd_lookup_values fvl1
4308: , fnd_lookup_values fvl10
4309: , fnd_lookup_values fvl14
4310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4311: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 4308: , fnd_lookup_values fvl10

4304: , h2.GL_DATE source_18
4305: FROM xla_events_gt xet
4306: , LNS_LOAN_HEADERS_EXT_V h2
4307: , fnd_lookup_values fvl1
4308: , fnd_lookup_values fvl10
4309: , fnd_lookup_values fvl14
4310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4311: and xet.event_type_code = C_EVENT_TYPE_CODE
4312: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 4309: , fnd_lookup_values fvl14

4305: FROM xla_events_gt xet
4306: , LNS_LOAN_HEADERS_EXT_V h2
4307: , fnd_lookup_values fvl1
4308: , fnd_lookup_values fvl10
4309: , fnd_lookup_values fvl14
4310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4311: and xet.event_type_code = C_EVENT_TYPE_CODE
4312: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
4313: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 4375: , fnd_lookup_values fvl4

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
4379: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 4376: , fnd_lookup_values fvl6

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
4379: WHERE xet.event_id between x_first_event_id and x_last_event_id
4380: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 4377: , fnd_lookup_values fvl8

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
4379: WHERE xet.event_id between x_first_event_id and x_last_event_id
4380: and xet.event_date between p_pad_start_date and p_pad_end_date
4381: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 4378: , fnd_lookup_values fvl12

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
4379: WHERE xet.event_id between x_first_event_id and x_last_event_id
4380: and xet.event_date between p_pad_start_date and p_pad_end_date
4381: and xet.event_type_code = C_EVENT_TYPE_CODE
4382: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 5239: , fnd_lookup_values fvl1

5235: ELSE null
5236: END source_meaning
5237: FROM xla_events_gt xet
5238: , LNS_LOAN_HEADERS_EXT_V h2
5239: , fnd_lookup_values fvl1
5240: , fnd_lookup_values fvl10
5241: , fnd_lookup_values fvl14
5242: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5243: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 5240: , fnd_lookup_values fvl10

5236: END source_meaning
5237: FROM xla_events_gt xet
5238: , LNS_LOAN_HEADERS_EXT_V h2
5239: , fnd_lookup_values fvl1
5240: , fnd_lookup_values fvl10
5241: , fnd_lookup_values fvl14
5242: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5243: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5244: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 5241: , fnd_lookup_values fvl14

5237: FROM xla_events_gt xet
5238: , LNS_LOAN_HEADERS_EXT_V h2
5239: , fnd_lookup_values fvl1
5240: , fnd_lookup_values fvl10
5241: , fnd_lookup_values fvl14
5242: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
5243: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5244: AND xet.event_class_code = C_EVENT_CLASS_CODE
5245: AND h2.event_id = xet.event_id

Line 5382: , fnd_lookup_values fvl4

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
5386: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 5383: , fnd_lookup_values fvl6

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
5386: AND xet.event_class_code = C_EVENT_CLASS_CODE
5387: AND l1.event_id = xet.event_id

Line 5524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

5520: l_balance_type_code VARCHAR2(1) :=NULL;
5521: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
5522:
5523: --
5524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
5525: --
5526:
5527: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
5528: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 5609: , fnd_lookup_values fvl1

5605: , h2.EXCHANGE_RATE_TYPE source_17
5606: , h2.GL_DATE source_18
5607: FROM xla_events_gt xet
5608: , LNS_LOAN_HEADERS_EXT_V h2
5609: , fnd_lookup_values fvl1
5610: , fnd_lookup_values fvl10
5611: , fnd_lookup_values fvl14
5612: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
5613: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 5610: , fnd_lookup_values fvl10

5606: , h2.GL_DATE source_18
5607: FROM xla_events_gt xet
5608: , LNS_LOAN_HEADERS_EXT_V h2
5609: , fnd_lookup_values fvl1
5610: , fnd_lookup_values fvl10
5611: , fnd_lookup_values fvl14
5612: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
5613: and xet.event_class_code = C_EVENT_CLASS_CODE
5614: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 5611: , fnd_lookup_values fvl14

5607: FROM xla_events_gt xet
5608: , LNS_LOAN_HEADERS_EXT_V h2
5609: , fnd_lookup_values fvl1
5610: , fnd_lookup_values fvl10
5611: , fnd_lookup_values fvl14
5612: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
5613: and xet.event_class_code = C_EVENT_CLASS_CODE
5614: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
5615: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 5672: , fnd_lookup_values fvl4

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
5676: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 5673: , fnd_lookup_values fvl6

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
5676: and xet.event_class_code = C_EVENT_CLASS_CODE
5677: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 6484: , fnd_lookup_values fvl1

6480: ELSE null
6481: END source_meaning
6482: FROM xla_events_gt xet
6483: , LNS_LOAN_HEADERS_EXT_V h1
6484: , fnd_lookup_values fvl1
6485: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
6486: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6487: AND xet.event_type_code = C_EVENT_TYPE_CODE
6488: AND h1.event_id = xet.event_id

Line 6623: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

6619: l_balance_type_code VARCHAR2(1) :=NULL;
6620: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
6621:
6622: --
6623: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6624: --
6625:
6626: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
6627: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 6676: , fnd_lookup_values fvl1

6672: , h1.LOAN_NUMBER source_3
6673: , h1.GL_DATE source_18
6674: FROM xla_events_gt xet
6675: , LNS_LOAN_HEADERS_EXT_V h1
6676: , fnd_lookup_values fvl1
6677: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6678: and xet.event_type_code = C_EVENT_TYPE_CODE
6679: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
6680: AND fvl1.lookup_type(+) = 'LOAN_CLASS'