[Home] [Help]
5882:
5883: ELSE null
5884: END source_value
5885: , null source_meaning
5886: FROM xla_events_gt xet
5887: , FV_BE_BA_FD_HDR_V h1
5888: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
5889: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
5890: AND xet.event_class_code = C_EVENT_CLASS_CODE
6058: ,xet.reference_date_4
6059: ,xet.event_created_by
6060: ,xet.budgetary_control_flag
6061: , h1.GL_DATE source_25
6062: FROM xla_events_gt xet
6063: , FV_BE_BA_FD_HDR_V h1
6064: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6065: and xet.event_class_code = C_EVENT_CLASS_CODE
6066: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
6098: ,xet.reference_date_4
6099: ,xet.event_created_by
6100: ,xet.budgetary_control_flag
6101: , 0
6102: FROM xla_events_gt xet
6103: WHERE xet.event_id between x_first_event_id and x_last_event_id
6104: and xet.event_date between p_pad_start_date and p_pad_end_date
6105: and xet.event_class_code = C_EVENT_CLASS_CODE
6106: and xet.event_status_code <> 'N' ;
6771:
6772: ELSE null
6773: END source_value
6774: , null source_meaning
6775: FROM xla_events_gt xet
6776: , FV_BE_RPR_HDR_V h1
6777: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
6778: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6779: AND xet.event_class_code = C_EVENT_CLASS_CODE
6947: ,xet.reference_date_4
6948: ,xet.event_created_by
6949: ,xet.budgetary_control_flag
6950: , h1.GL_DATE source_25
6951: FROM xla_events_gt xet
6952: , FV_BE_RPR_HDR_V h1
6953: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6954: and xet.event_class_code = C_EVENT_CLASS_CODE
6955: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
6987: ,xet.reference_date_4
6988: ,xet.event_created_by
6989: ,xet.budgetary_control_flag
6990: , 0
6991: FROM xla_events_gt xet
6992: WHERE xet.event_id between x_first_event_id and x_last_event_id
6993: and xet.event_date between p_pad_start_date and p_pad_end_date
6994: and xet.event_class_code = C_EVENT_CLASS_CODE
6995: and xet.event_status_code <> 'N' ;
7674: WHEN 2 THEN fvl9.meaning
7675:
7676: ELSE null
7677: END source_meaning
7678: FROM xla_events_gt xet
7679: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
7680: , FV_TREASURY_EXTRACT_HEADER_V h3
7681: , fnd_lookup_values fvl9
7682: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
7873:
7874: ELSE null
7875: END source_value
7876: , null source_meaning
7877: FROM xla_events_gt xet
7878: , FV_TREASURY_EXTRACT_DETAILS_V l2
7879: , (select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
7880: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7881: AND xet.event_class_code = C_EVENT_CLASS_CODE
8094: , h1.ASP_WHEN_TO_ACCOUNT_PMT source_5
8095: , h1.ASP_AUTOMATIC_OFFSETS_VALUE source_9
8096: , fvl9.meaning source_9_meaning
8097: , h3.TREASURY_CONFIRMATION_ID source_13
8098: FROM xla_events_gt xet
8099: , AP_SYSTEM_PARAMETERS_EXTRACT_V h1
8100: , FV_TREASURY_EXTRACT_HEADER_V h3
8101: , fnd_lookup_values fvl9
8102: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8160: , l2.FV_INV_EXCHANGE_DATE source_21
8161: , l2.FV_INV_EXCHANGE_RATE source_22
8162: , l2.FV_INV_EXCHANGE_RATE_TYPE source_23
8163: , l2.FV_REV_PAY_HIST_DIST_ID source_24
8164: FROM xla_events_gt xet
8165: , FV_TREASURY_EXTRACT_DETAILS_V l2
8166: WHERE xet.event_id between x_first_event_id and x_last_event_id
8167: and xet.event_date between p_pad_start_date and p_pad_end_date
8168: and xet.event_class_code = C_EVENT_CLASS_CODE
9162: ,p_level => C_LEVEL_STATEMENT
9163: ,p_module => l_log_module);
9164:
9165: trace
9166: (p_msg => '# of events in xla_events_gt: '
9167: ||xla_context_pkg.get_event_count_context
9168: ,p_level => C_LEVEL_STATEMENT
9169: ,p_module => l_log_module);
9170: