Query : Requisition to PO

PO_HEADERS_ALL
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL

POR_REQUISITION_HEADERS_ALL
POR_REQUISITION_LINES_ALL
POR_REQ_DISTRIBUTIONS_ALL

select
prh.requisition_number,
prl.requisition_header_id,
prl.requisition_line_id,
prd.distribution_id,
prd.attribute12 "REQ A12"

from

POR_REQ_DISTRIBUTIONS_ALL prd,
por_requisition_headers_all prh,
por_requisition_lines_all prl

where

prh.requisition_header_id = prl.requisition_header_id and
prl.requisition_line_id = prd.requisition_line_id and
prh.requisition_number = '10010035498';