select distinct ord.order_number from oe_order_headers_all ord, wsh_delivery_details det, apps.WSH_DSNO_DELIVERY_ATTRIBS_V asg, wsh_delivery_assignments dre where det.source_header_id = ord.header_id and dre.delivery_detail_id = det.delivery_detail_id and dre.delivery_id=asg.delivery_id
and dre.delivery_id=$delivery_id
欢迎 大家访问 Oracle Application 11i Blog http://blog.sina.com.cn/u/1213167713
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2006/1/17 22:00:01
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡