码报表二级计划语句.pdfVIP

Selectdistinctt1.project_idproject_id,

t7.projectnameprojectname,

to_char(sysdate,yyyy-MM-dd)ZBDate,

T1.programcode||||t1.programnameasprogram,

T2.wbscode2||||t2.wbsname2asfunctionarea,

T3.wbscode3||||t3.wbsname3asplant,

T4.wbscode4||||t4.wbsname4asphase,

T10.wbscode10||||t10.wbsname10asdiscipline,

T5.cbsascbs,

T6.obsasobs,

T8.documentdocument,

T9.materialmaterial

Fromunifier_ux021t1

leftjoin(selectwbscodewbscode2,wbsnamewbsname2,wbspidwbspid2,project_idfrom

unifier_ux020

wh