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 FND_LOOKUP_VALUES

Line 2953: , fnd_lookup_values fvl1

2949: ELSE null
2950: END source_meaning
2951: FROM xla_events_gt xet
2952: , LNS_LOAN_HEADERS_EXT_V h2
2953: , fnd_lookup_values fvl1
2954: , fnd_lookup_values fvl10
2955: , fnd_lookup_values fvl14
2956: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
2957: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 2954: , fnd_lookup_values fvl10

2950: END source_meaning
2951: FROM xla_events_gt xet
2952: , LNS_LOAN_HEADERS_EXT_V h2
2953: , fnd_lookup_values fvl1
2954: , fnd_lookup_values fvl10
2955: , fnd_lookup_values fvl14
2956: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
2957: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2958: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 2955: , fnd_lookup_values fvl14

2951: FROM xla_events_gt xet
2952: , LNS_LOAN_HEADERS_EXT_V h2
2953: , fnd_lookup_values fvl1
2954: , fnd_lookup_values fvl10
2955: , fnd_lookup_values fvl14
2956: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
2957: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2958: AND xet.event_class_code = C_EVENT_CLASS_CODE
2959: AND h2.event_id = xet.event_id

Line 3113: , fnd_lookup_values fvl4

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

Line 3114: , fnd_lookup_values fvl6

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

Line 3115: , fnd_lookup_values fvl8

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

Line 3116: , fnd_lookup_values fvl12

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
3117: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
3118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3119: AND xet.event_class_code = C_EVENT_CLASS_CODE
3120: AND l1.event_id = xet.event_id

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

3261: l_balance_type_code VARCHAR2(1) :=NULL;
3262: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
3263:
3264: --
3265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
3266: --
3267:
3268: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
3269: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3358: , fnd_lookup_values fvl1

3354: , h2.EXCHANGE_RATE_TYPE source_17
3355: , h2.GL_DATE source_18
3356: FROM xla_events_gt xet
3357: , LNS_LOAN_HEADERS_EXT_V h2
3358: , fnd_lookup_values fvl1
3359: , fnd_lookup_values fvl10
3360: , fnd_lookup_values fvl14
3361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3362: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 3359: , fnd_lookup_values fvl10

3355: , h2.GL_DATE source_18
3356: FROM xla_events_gt xet
3357: , LNS_LOAN_HEADERS_EXT_V h2
3358: , fnd_lookup_values fvl1
3359: , fnd_lookup_values fvl10
3360: , fnd_lookup_values fvl14
3361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3362: and xet.event_class_code = C_EVENT_CLASS_CODE
3363: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 3360: , fnd_lookup_values fvl14

3356: FROM xla_events_gt xet
3357: , LNS_LOAN_HEADERS_EXT_V h2
3358: , fnd_lookup_values fvl1
3359: , fnd_lookup_values fvl10
3360: , fnd_lookup_values fvl14
3361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3362: and xet.event_class_code = C_EVENT_CLASS_CODE
3363: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
3364: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 3426: , fnd_lookup_values fvl4

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

Line 3427: , fnd_lookup_values fvl6

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

Line 3428: , fnd_lookup_values fvl8

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
3430: WHERE xet.event_id between x_first_event_id and x_last_event_id
3431: and xet.event_date between p_pad_start_date and p_pad_end_date
3432: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 3429: , fnd_lookup_values fvl12

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
3430: WHERE xet.event_id between x_first_event_id and x_last_event_id
3431: and xet.event_date between p_pad_start_date and p_pad_end_date
3432: and xet.event_class_code = C_EVENT_CLASS_CODE
3433: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 4290: , fnd_lookup_values fvl1

4286: ELSE null
4287: END source_meaning
4288: FROM xla_events_gt xet
4289: , LNS_LOAN_HEADERS_EXT_V h2
4290: , fnd_lookup_values fvl1
4291: , fnd_lookup_values fvl10
4292: , fnd_lookup_values fvl14
4293: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 4291: , fnd_lookup_values fvl10

4287: END source_meaning
4288: FROM xla_events_gt xet
4289: , LNS_LOAN_HEADERS_EXT_V h2
4290: , fnd_lookup_values fvl1
4291: , fnd_lookup_values fvl10
4292: , fnd_lookup_values fvl14
4293: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4295: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 4292: , fnd_lookup_values fvl14

4288: FROM xla_events_gt xet
4289: , LNS_LOAN_HEADERS_EXT_V h2
4290: , fnd_lookup_values fvl1
4291: , fnd_lookup_values fvl10
4292: , fnd_lookup_values fvl14
4293: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
4294: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4295: AND xet.event_class_code = C_EVENT_CLASS_CODE
4296: AND h2.event_id = xet.event_id

Line 4433: , fnd_lookup_values fvl4

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

Line 4434: , fnd_lookup_values fvl6

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

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

4571: l_balance_type_code VARCHAR2(1) :=NULL;
4572: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
4573:
4574: --
4575: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
4576: --
4577:
4578: TYPE t_array_source_1 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
4579: TYPE t_array_source_2 IS TABLE OF LNS_LOAN_HEADERS_EXT_V.LOAN_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4660: , fnd_lookup_values fvl1

4656: , h2.EXCHANGE_RATE_TYPE source_17
4657: , h2.GL_DATE source_18
4658: FROM xla_events_gt xet
4659: , LNS_LOAN_HEADERS_EXT_V h2
4660: , fnd_lookup_values fvl1
4661: , fnd_lookup_values fvl10
4662: , fnd_lookup_values fvl14
4663: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4664: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 4661: , fnd_lookup_values fvl10

4657: , h2.GL_DATE source_18
4658: FROM xla_events_gt xet
4659: , LNS_LOAN_HEADERS_EXT_V h2
4660: , fnd_lookup_values fvl1
4661: , fnd_lookup_values fvl10
4662: , fnd_lookup_values fvl14
4663: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4664: and xet.event_class_code = C_EVENT_CLASS_CODE
4665: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 4662: , fnd_lookup_values fvl14

4658: FROM xla_events_gt xet
4659: , LNS_LOAN_HEADERS_EXT_V h2
4660: , fnd_lookup_values fvl1
4661: , fnd_lookup_values fvl10
4662: , fnd_lookup_values fvl14
4663: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4664: and xet.event_class_code = C_EVENT_CLASS_CODE
4665: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
4666: AND fvl1.lookup_type(+) = 'LOAN_CLASS'

Line 4723: , fnd_lookup_values fvl4

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

Line 4724: , fnd_lookup_values fvl6

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