sql – wyciąga zlecenia, które mają ustawiony harmonogram

1
2
3
4
5
6
7
8
9

 SELECT t.Program,
       t.Requested_Start_Date,
       u.user_name,
       u.description,
       t.Argument_Text
  FROM apps.fnd_conc_requests_form_v t, fnd_user u
 WHERE t.sch_curr_values IS NOT NULL
   AND SYSDATE <
t.Requested_Start_Date AND u.user_id = t.Requested_By

select t.Program, t.Requested_Start_Date, u.user_name, u.description, t.Argument_Text from apps.fnd_conc_requests_form_v t, fnd_user u where t.sch_curr_values is not null and sysdate < t.Requested_Start_Date and u.user_id = t.Requested_By