select concurrent_program_id, program_application_id, printer,
program_short_name, argument_text, print_style,
user_print_style, save_output_flag, row_id,
actual_completion_date, completion_text, parent_request_id,
request_type, fcp_printer, fcp_print_style, fcp_required_style,
last_update_date, last_updated_by, requested_by,
has_sub_request, is_sub_request, update_protected,
queue_method_code, responsibility_application_id, responsibility_id,
controlling_manager, last_update_login, priority_request_id,
enabled, requested_start_date, phase_code,
hold_flag, status_code, request_id,
program, requestor, priority
from fnd_conc_req_summary_v
where 1=1
and phase_code = 'P'
and status_code in ('I', 'Q')
and ((decode(implicit_code, 'N', status_code,'E', 'E', 'W', 'G') = status_code or decode(implicit_code, 'W', 'E') = status_code))
order by request_id desc-- check Concurrent All
select concurrent_program_id, program_application_id, printer,
program_short_name, argument_text, print_style,
user_print_style, save_output_flag, row_id,
actual_completion_date, completion_text, parent_request_id,
request_type, fcp_printer, fcp_print_style, fcp_required_style,
last_update_date, last_updated_by, requested_by,
has_sub_request, is_sub_request, update_protected,
queue_method_code, responsibility_application_id, responsibility_id,
controlling_manager, last_update_login, priority_request_id,
enabled, requested_start_date, phase_code,
hold_flag, status_code, request_id,
program, requestor, priority
from fnd_conc_req_summary_v
where 1=1
and phase_code = 'P'
and status_code in ('I', 'Q')
and ((decode(implicit_code, 'N', status_code,'E', 'E', 'W', 'G') = status_code or decode(implicit_code, 'W', 'E') = status_code))
order by request_id desc
No comments:
Post a Comment