博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

po收货的SQL

Posted on 2012-06-26 15:11  奥客  阅读(221)  评论(0编辑  收藏  举报

 

begin
     fnd_client_info.set_org_context(82);
end;

select * from  PO_LINE_LOCATIONS_V

 


select pll.*
from po_headers_all ph, PO_LINES_ALL pl ,po_line_locations_all pll
where pll.po_line_id=pl.po_line_id
and pll.po_header_id=pl.po_header_id
and pl.po_header_id=ph.po_header_id
and ph.segment1='19738' 17621

select * from RCV_TRANSACTIONS rt where rt.po_line_location_id in (283171,285586,285587)


select rcv.TRANSACTION_QUANTITY,rcv.*
from rcv_enter_receipts_v rcv where rcv.PO_LINE_LOCATION_ID in (283171,285586,285587)