Şub
25
2014

Teslim Almasi Yapılan Satınalma Siparişlerini(PO) listeleyen SQL

Yazar Aşkın Er Yorumlar

select pv.vendor_name as vendor,
to_date (rt.transaction_date, ‘DD-MM-YYYY’) as receipt_date,
rt.subinventory as subinventory_code,
(select organization_name
from apps.org_organization_definitions
where organization_id = rt.organization_id) as organization_name,
rsh.receipt_num as receipt_number,
rsh.attribute_category as attribute_category,
rsl.quantity_received as quantity_received,
rsl.item_description as item_description,
pha.segment1 as po_number,
plla.quantity as po_quantity,
fu.description
from po.rcv_transactions rt,
po.rcv_shipment_headers rsh,
po.rcv_shipment_lines rsl,
po.po_vendors pv,
po.po_headers_all pha,
po.po_line_locations_all plla,
po.po_lines_all pla,
applsys.fnd_user fu
where 1=1
and rt.transaction_type=’DELIVER’
and rsh.shipment_header_id = rsl.shipment_header_id
and rt.shipment_header_id = rsl.shipment_header_id
and rt.shipment_line_id = rsl.shipment_line_id
and rt.vendor_id = pv.vendor_id(+)
and rt.po_header_id=pha.po_header_id(+)
and rsl.po_line_location_id = plla.line_location_id
and plla.po_line_id = pla.po_line_id
and pla.po_line_id(+) = rt.po_line_id
and pha.created_by = fu.user_id