SELECT WE.ORGANIZATION_ID,
WE.WIP_ENTITY_ID,
WE.WIP_ENTITY_NAME,
POD.PO_HEADER_ID,
PHA.SEGMENT1 PO_NUM,--採購單號
POR.RELEASE_NUM,--焜放單號
PHA.VENDOR_ID,
PV.VENDOR_NAME ---供應商
FROM WIP_ENTITIES WE,
PO_DISTRIBUTIONS_ALL POD,
PO_HEADERS_ALL PHA,
PO_RELEASES_ALL POR,
---PO_LINES_ALL PLA
PO_VENDORS PV
WHERE 1=1
AND WE.WIP_ENTITY_NAME='S1015136'
AND POD.WIP_ENTITY_ID=WE.WIP_ENTITY_ID
AND POD.DESTINATION_ORGANIZATION_ID=WE.ORGANIZATION_ID
AND PHA.PO_HEADER_ID=POD.PO_HEADER_ID
--AND PLA.PO_LINE_ID=POD.PO_LINE_ID
AND POD.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
AND PV.VENDOR_ID=PHA.VENDOR_ID
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41594/viewspace-50532/，如需转载，请注明出处，否则将追究法律责任。
