| SQL("Umgg_zs","select * from(select distinct nvl( cha.project_name,'无项目名') as project_name from apps.cux_cm_boxes_v b,apps.CUX_CM_CONTRACT_HEADERS_ALL cha,cux_cm_box_detail d where b.contract_header_id =cha.contract_header_id(+) and b.box_id=d.box_id(+) and b.status <> 'CANCELED' and cha.shipment_date is not null and not exists (select box_id from CUX_WIP_BOX_COMPLETION wbc where wbc.organization_id = '"+$company+"' and wbc.status <> 'CANCELED' and wbc.status = 'CONFIRMED' and wbc.box_id = b.box_id) and (b.org_id = '"+$company+"') "+joinarray(maparray(SubSection(($label7))," and d.box_detail_id not in "+item),"")+")where 1=1 ORDER by nlssort (project_name,'NLS_SORT=SCHINESE_PINYIN_M')",1) |
