1.先查找该页面的视图:得PO_LINE_LOCATIONS_INQ_V
2.查找到视图的栏位是哪个table 得到:
po_line_locations_all --pll
DECODE (pll.match_option, 'P', 'PO', 'R', 'Receipt', 'PO'),
3.所以是那里为'P',值为PO 不能match.
select poh.segment1 --20601404
from
po_headers_all poh,
po_lines_all pol,
po_line_locations_all poll,
rcv_shipment_lines rsl,
rcv_shipment_headers
rsh
where
poh.po_header_id=pol.po_header_id
and
pol.po_line_id=poll.po_line_id
and poll.line_location_id= rsl.po_line_location_id
and rsh.shipment_header_id=rsl.shipment_header_id
and rsh.receipt_num=60002831
4.查一下结果果然是,查询语句:
select pll.match_option , pll.po_line_id /*查询结果是 P 和 156363*/
from po_line_locations_all pll,
po_headers_all poh,
po_lines_all pol
where
poh.po_header_id=pol.po_header_id
and pol.po_line_id=pll.po_line_id
and poh.segment1='20600620'
5.修改pll.match_option 为'R'就可以了:
update po_line_locations_all
set match_option='R'
where po_line_id='156363'
commit;
最后,需要让user 去修改一下supplier 的设置, control- invoice match option , 选择 receipt .
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/226700/viewspace-846053/ ，如需转载，请注明出处，否则将追究法律责任。
