Query to find out PR and PO linked (Find PO information Against PR)
select req.segment1,req.DESCRIPTION req_,req.APPROVED_DATE,po.segment1,po.CREATION_DATE,po.APPROVED_FLAG
from po_headers_all po,
po_distributions_all dst,
po_req_distributions_all rd,
po_requisition_lines_all rl,
po_requisition_headers_all req
where po.po_header_id = dst.po_header_id
and dst.req_distribution_id = rd.distribution_id
and rd.requisition_line_id = rl.requisition_line_id
and rl.requisition_header_id = req.requisition_header_id
from po_headers_all po,
po_distributions_all dst,
po_req_distributions_all rd,
po_requisition_lines_all rl,
po_requisition_headers_all req
where po.po_header_id = dst.po_header_id
and dst.req_distribution_id = rd.distribution_id
and rd.requisition_line_id = rl.requisition_line_id
and rl.requisition_header_id = req.requisition_header_id
No comments:
Post a Comment