[Home] [Help]
2920: WHEN 1 THEN fvl1.meaning
2921:
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
3112: , fvl1.meaning source_1_meaning
3113: , h1.LOAN_TYPE source_2
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
3157: ,xet.reference_date_3
3158: ,xet.reference_date_4
3159: ,xet.event_created_by
3160: ,xet.budgetary_control_flag , 0
3161: FROM xla_events_gt xet
3162: WHERE xet.event_id between x_first_event_id and x_last_event_id
3163: and xet.event_date between p_pad_start_date and p_pad_end_date
3164: and xet.event_type_code = C_EVENT_TYPE_CODE
3165: and xet.event_status_code <> 'N' ;
3896: WHEN 5 THEN fvl14.meaning
3897:
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
4055: WHEN 8 THEN fvl12.meaning
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
4301: , h2.EXCHANGE_DATE source_15
4302: , h2.EXCHANGE_RATE source_16
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
4369: , l1.DISTRIBUTION_ID source_11
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
5233: WHEN 5 THEN fvl14.meaning
5234:
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
5376: WHEN 3 THEN fvl6.meaning
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)
5603: , h2.EXCHANGE_DATE source_15
5604: , h2.EXCHANGE_RATE source_16
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
5666: , fvl6.meaning source_6_meaning
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
6478: WHEN 1 THEN fvl1.meaning
6479:
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
6670: , fvl1.meaning source_1_meaning
6671: , h1.LOAN_TYPE source_2
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
6715: ,xet.reference_date_3
6716: ,xet.reference_date_4
6717: ,xet.event_created_by
6718: ,xet.budgetary_control_flag , 0
6719: FROM xla_events_gt xet
6720: WHERE xet.event_id between x_first_event_id and x_last_event_id
6721: and xet.event_date between p_pad_start_date and p_pad_end_date
6722: and xet.event_type_code = C_EVENT_TYPE_CODE
6723: and xet.event_status_code <> 'N' ;
7492: ,p_level => C_LEVEL_STATEMENT
7493: ,p_module => l_log_module);
7494:
7495: trace
7496: (p_msg => '# of events in xla_events_gt: '
7497: ||xla_context_pkg.get_event_count_context
7498: ,p_level => C_LEVEL_STATEMENT
7499: ,p_module => l_log_module);
7500: