ERP11.5.9常用SQL

yusheng

/*寻找系统的错误数据，下步的处理是把待定事务的ID-pnd.line_detail_id改为发运事务ID-WDV.delivery_line_id*/

select pnd.line_detail_id,WDV.delivery_line_id,PND.TRANS_QTY,WDV.requested_quantity,h.order_number,/*hh.line_number*/hh.line_id,hh.ordered_item,PND.CO_CODE,
hh.ordered_quantity,pnd.line_detail_id ,WDV.delivery_line_id,pnd.trans_id,wdv.released_status_name,
wdv.source_line_number,pnd.trans_qty,wdv.container_flag,WDV.OE_INTERFACED_FLAG,WDV.INV_INTERFACED_FLAG,wdv.*
FROM IC_TRAN_PND PND ,oe_order_lines_all hh,
wsh_deliverables_v    wdv, oe_order_headers_all h

where /*pnd.line_id like '350186'
AND */
hh.header_id=h.header_id
and PND.LOT_ID <>'0'
AND PND.CO_CODE='YGDD'
and pnd.delete_mark=0
and pnd.doc_type='OMSO'
AND PND.COMPLETED_IND=0
/*and hh.flow_status_code='CLOSED'*/
AND HH.CANCELLED_FLAG='N'
AND HH.BOOKED_FLAG='Y'
and hh.line_id=pnd.line_id
and wdv.source_line_id=pnd.line_id
and pnd.line_detail_id<>WDV.delivery_line_id
/*and pnd.line_detail_id=WDV.delivery_line_id*/
/*and wdv.released_status='C'*/
and wdv.released_status_name<>'已连接'
AND WDV.inv_interfaced_flag <> 'Y'
/*and pnd.line_id=553993*/
and wdv.split_from_delivery_detail_id IS NOT NULL
AND PND.TRANS_QTY=(-WDV.requested_quantity)
/*
and wdv.released_status_name='发运'
and wdv.released_status='C'
and wdv.inv_interfaced_flag='P'*/

/*AND H.ORDER_NUMBER='10000006445'*/

/*AND PND.TRANS_QTY=-82*/

Star_2122

學習中