Monday, November 6, 2017

How to update two way POs from Receipt to PO

update PO_LINE_LOCATIONS_ALL pll set pll.match_option='P'
where 
pll.inspection_required_flag='N'
and pll.receipt_required_flag='N'
and pll.match_option='R'