Advertisement
psi_mmobile

Untitled

Jan 5th, 2021
1,387
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.91 KB | None | 0 0
  1. SELECT WbsTask.WBS_TASK_ID,
  2.        WbsTask.OBJECT_CODE_ID,
  3.        WbsTask.ACTIVITY_ID,
  4.        WbsTask.WBS_TASK_STRING,
  5.        WbsTask.DESCRIPTION,
  6.        WbsTask.FROM_DATE,
  7.        WbsTask.TO_DATE,
  8.        WbsTask.LM_DATE,
  9.        WbsTask.LM_NAME,
  10.        WbsTask.IS_WORK_TIME_REPORTED,
  11.        Activity.ACTIVITY_CODE,
  12.        Activity.ACTIVITY_ID AS ACTIVITY_ID1,
  13.        Activity.ACTIVITY_NAME,
  14.        ObjectCode.OBJECT_CODE_STRING,
  15.        ObjectCode.OBJECT_CODE_ID AS OBJECT_CODE_ID1,
  16.        WbsTask.WBS_ID,
  17.        WbsTask.ASSEMBLY_HR,
  18.        WbsTask.ASSEMBLY_NAME,
  19.        WbsTask.ASSEMBLY_QUANTITY,
  20.        WbsTask.WBS_TASK_STATUS_ID
  21. FROM OF_OWNER.WBS_TASK WbsTask, OF_OWNER.ACTIVITY Activity, OF_OWNER.OBJECT_CODE ObjectCode
  22. WHERE (WbsTask.ACTIVITY_ID = Activity.ACTIVITY_ID) AND (WbsTask.OBJECT_CODE_ID = ObjectCode.OBJECT_CODE_ID)
  23. AND (WbsTask.WBS_TASK_STATUS_ID = 0 OR ? = 'true')
  24. ORDER BY 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement