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)