Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT WbsTask.WBS_TASK_ID,
- WbsTask.OBJECT_CODE_ID,
- WbsTask.ACTIVITY_ID,
- WbsTask.WBS_TASK_STRING,
- WbsTask.DESCRIPTION,
- WbsTask.FROM_DATE,
- WbsTask.TO_DATE,
- WbsTask.LM_DATE,
- WbsTask.LM_NAME,
- WbsTask.IS_WORK_TIME_REPORTED,
- Activity.ACTIVITY_CODE,
- Activity.ACTIVITY_ID AS ACTIVITY_ID1,
- Activity.ACTIVITY_NAME,
- ObjectCode.OBJECT_CODE_STRING,
- ObjectCode.OBJECT_CODE_ID AS OBJECT_CODE_ID1,
- WbsTask.WBS_ID,
- WbsTask.ASSEMBLY_HR,
- WbsTask.ASSEMBLY_NAME,
- WbsTask.ASSEMBLY_QUANTITY,
- WbsTask.WBS_TASK_STATUS_ID
- FROM OF_OWNER.WBS_TASK WbsTask, OF_OWNER.ACTIVITY Activity, OF_OWNER.OBJECT_CODE ObjectCode
- WHERE (WbsTask.ACTIVITY_ID = Activity.ACTIVITY_ID) AND (WbsTask.OBJECT_CODE_ID = ObjectCode.OBJECT_CODE_ID)
- AND (WbsTask.WBS_TASK_STATUS_ID = 0 OR ? = 'true')
- ORDER BY 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement