Search This Blog

Sunday, November 21, 2010

Relation between Requisition And PO

 SELECT
,r.segment1 "Req Num"
,p.segment1 "PO Num"
from
,po_headers_all p
,po_distributions_all d
,po_req_distributions_all rd
,po_requisition_lines_all rl
,po_requisition_headers_all r
WHERE
p.po_header_id = d.po_header_id and
d.req_distribution_id = rd.distribution_id and
rd.requisition_line_id = rl.requisition_line_id and
rl.requisition_header_id = r.requisition_header_id

2 comments:

  1. hi sir gud evng
    could plz help ma wat is link between PO and INV

    ReplyDelete
  2. Well connected to Major Expressway such as Pan-Island Expressway (PIE) and Central Expressway
    (CTE) to get you to places in no time. the interlace condo

    ReplyDelete