[Home] [Help]
10663: WHEN 20 THEN fvl22.meaning
10664:
10665: ELSE null
10666: END source_meaning
10667: FROM xla_events_gt xet
10668: , CE_XLA_EXT_HEADERS_V h1
10669: , fnd_lookup_values fvl22
10670: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
10671: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10924: , h1.CF_EXCHANGE_DATE source_26
10925: , h1.CF_EXCHANGE_RATE source_27
10926: , h1.CF_EXCHANGE_RATE_TYPE source_28
10927: , h1.ACCOUNTING_DATE source_29
10928: FROM xla_events_gt xet
10929: , CE_XLA_EXT_HEADERS_V h1
10930: , fnd_lookup_values fvl22
10931: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10932: and xet.event_type_code = C_EVENT_TYPE_CODE
10969: ,xet.reference_date_3
10970: ,xet.reference_date_4
10971: ,xet.event_created_by
10972: ,xet.budgetary_control_flag , 0
10973: FROM xla_events_gt xet
10974: WHERE xet.event_id between x_first_event_id and x_last_event_id
10975: and xet.event_date between p_pad_start_date and p_pad_end_date
10976: and xet.event_type_code = C_EVENT_TYPE_CODE
10977: and xet.event_status_code <> 'N' ;
12069: WHEN 20 THEN fvl22.meaning
12070:
12071: ELSE null
12072: END source_meaning
12073: FROM xla_events_gt xet
12074: , CE_XLA_EXT_HEADERS_V h1
12075: , fnd_lookup_values fvl22
12076: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
12077: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12330: , h1.CF_EXCHANGE_DATE source_26
12331: , h1.CF_EXCHANGE_RATE source_27
12332: , h1.CF_EXCHANGE_RATE_TYPE source_28
12333: , h1.ACCOUNTING_DATE source_29
12334: FROM xla_events_gt xet
12335: , CE_XLA_EXT_HEADERS_V h1
12336: , fnd_lookup_values fvl22
12337: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
12338: and xet.event_type_code = C_EVENT_TYPE_CODE
12375: ,xet.reference_date_3
12376: ,xet.reference_date_4
12377: ,xet.event_created_by
12378: ,xet.budgetary_control_flag , 0
12379: FROM xla_events_gt xet
12380: WHERE xet.event_id between x_first_event_id and x_last_event_id
12381: and xet.event_date between p_pad_start_date and p_pad_end_date
12382: and xet.event_type_code = C_EVENT_TYPE_CODE
12383: and xet.event_status_code <> 'N' ;
13430: WHEN 16 THEN fvl22.meaning
13431:
13432: ELSE null
13433: END source_meaning
13434: FROM xla_events_gt xet
13435: , CE_XLA_EXT_HEADERS_V h1
13436: , fnd_lookup_values fvl22
13437: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
13438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13664: , h1.CF_DIRECTION source_22
13665: , fvl22.meaning source_22_meaning
13666: , h1.CF_CLEARED_AMOUNT source_23
13667: , h1.ACCOUNTING_DATE source_29
13668: FROM xla_events_gt xet
13669: , CE_XLA_EXT_HEADERS_V h1
13670: , fnd_lookup_values fvl22
13671: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
13672: and xet.event_class_code = C_EVENT_CLASS_CODE
13709: ,xet.reference_date_4
13710: ,xet.event_created_by
13711: ,xet.budgetary_control_flag
13712: , 0
13713: FROM xla_events_gt xet
13714: WHERE xet.event_id between x_first_event_id and x_last_event_id
13715: and xet.event_date between p_pad_start_date and p_pad_end_date
13716: and xet.event_class_code = C_EVENT_CLASS_CODE
13717: and xet.event_status_code <> 'N' ;
14627: ,p_level => C_LEVEL_STATEMENT
14628: ,p_module => l_log_module);
14629:
14630: trace
14631: (p_msg => '# of events in xla_events_gt: '
14632: ||xla_context_pkg.get_event_count_context
14633: ,p_level => C_LEVEL_STATEMENT
14634: ,p_module => l_log_module);
14635: