转:http://blog.itpub.net/41594/viewspace-695850/
1.背景:通常是被取消请购行,是采购员把PO和对应PR取消后,
PR仍出现自动创建里面,也就是请购池里
PR仍出现自动创建里面,也就是请购池里
2.解决方法:使PRL.REQS_IN_POOL_FLAG置为null 或N
SELECT
PRH.SEGMENT1,
PRL.LINE_NUM,
PRL.REQUISITION_LINE_ID,
PRH.AUTHORIZATION_STATUS,
PRL.QUANTITY,
PRL.QUANTITY_CANCELLED,
PRL.CANCEL_FLAG,
PRL.REQS_IN_POOL_FLAG,PRL.REQUISITION_LINE_ID
FROM PO_REQUISITION_HEADERS_ALL PRH,
PO_REQUISITION_LINES_ALL PRL
WHERE PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_ID
AND PRL.REQS_IN_POOL_FLAG='Y'
AND PRL.CANCEL_FLAG='Y'
AND PRL.QUANTITY=0;
SELECT
PRH.SEGMENT1,
PRL.LINE_NUM,
PRL.REQUISITION_LINE_ID,
PRH.AUTHORIZATION_STATUS,
PRL.QUANTITY,
PRL.QUANTITY_CANCELLED,
PRL.CANCEL_FLAG,
PRL.REQS_IN_POOL_FLAG,PRL.REQUISITION_LINE_ID
FROM PO_REQUISITION_HEADERS_ALL PRH,
PO_REQUISITION_LINES_ALL PRL
WHERE PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_ID
AND PRL.REQS_IN_POOL_FLAG='Y'
AND PRL.CANCEL_FLAG='Y'
AND PRL.QUANTITY=0;
SELECT PRL.REQS_IN_POOL_FLAG
FROM PO_REQUISITION_LINES_ALL PRL
WHERE 1=1
AND PRL.REQUISITION_LINE_ID IN (96933,111289,121558,117682)
FOR UPDATE
FROM PO_REQUISITION_LINES_ALL PRL
WHERE 1=1
AND PRL.REQUISITION_LINE_ID IN (96933,111289,121558,117682)
FOR UPDATE