2014-06-03 Created By BaoXinjian一、从公关单位追溯到公关单位所需的方式和经过表
1 .在页面上从PO到PR的方向dsdyx/p(1).PO Header和Line
(2).PO Shipment
(3).po分布
2 .用SQL查询jzdpy/p (1) .总结
(2) .各条追溯
二、逐步在漂亮蝴蝶/p 1 .页面上从PO追溯PR方dsdyx/p(1).PO Header和Line
(2).PO Shipment
(3).po分布
2 .用SQL查询jzdpy/p (1) .总结
(2) .各条追溯
1 select po _ header _ id 23 from po _ headers _ all 45 where segment1=' 6050 ' 6789 select po _ line _ id 1011 from po _ lines _ all cations _ all 2021 where po _ line _ id=17330022232425 select po _ distributions _ all 2829 where line _ location _ id=26444425 _ ion _ id=20694338394041 select requisition _ header _ id 4243 from po _ requisition _ lines _ all 4445 where requisition _ s 253 where requisition _ header _ id=1812145455657 select PHA.po _ header 60 61 PLLA.line _ location _ id,62 63 PDA.req 64 65 prda .distribution_id,6667 prla.requisition 869 prha.requisition _ header _ id 7071 from po _ headers _ all PHA,765292; 7475 po _ line _ location ne 76 77po _ distributions _ all PDA、7879 po _ req _ distributions _ all prda、8081 po _ requisitition 283 po _ requisition _ headers _ allprha 8485 where PHA.po _ header _ id=PLA.po _ header _ id (8687 and PLA.po _ id ) and PDA.req _ distribution _ id=prda.distri iid 293 and prda.requisition _ line _ id=prla.requisition _ line _ id