Obtain Requisition Details
SELECT prla.po_header_id ,
prla.po_line_id ,
dha.source_order_system ,
dfla.source_order_number ,
dha.order_number ,
dfla.source_line_number ,
dfla.fulfill_line_number ,
dfla.status_code ,
dla.line_number ,
dla.display_line_number ,
dha.header_id ,
dfla.fulfill_line_id ,
dla.line_id ,
dfla.FULFILL_LINE_NUMBER ,
PRHA.REQUISITION_HEADER_ID ,
PRHA.REQUISITION_NUMBER ,
PRHA.DOCUMENT_STATUS ,
PRHA.PROCESS_STATUS ,
PRHA.REQ_BU_ID ,
PRHA.PREPARER_ID ,
PRHA.DESCRIPTION ,
PRLA.REQUISITION_LINE_ID ,
PRLA.SUGGESTED_VENDOR_NAME ,
PRLA.SUGGESTED_VENDOR_SITE ,
PRLA.VENDOR_ID ,
PRLA.VENDOR_SITE_ID ,
PRLA.ITEM_DESCRIPTION ,
PRLA.UOM_CODE ,
PRLA.UNIT_PRICE
FROM fusion.por_requisition_headers_all prha,
fusion.por_requisition_lines_all prla ,
fusion.doo_headers_all dha ,
fusion.doo_fulfill_lines_all dfla ,
fusion.doo_lines_all dla
WHERE prha.requisition_header_id = prla.requisition_header_id
AND dha.source_order_number IN ('&SOURCE_ORDER_NUMBER')
AND dha.header_id = dfla.header_id
AND TO_CHAR(dfla.fulfill_line_id) = prla.interface_LINE_KEY (+)
AND dha.submitted_flag = 'Y'
AND dfla.line_id = dla.line_id
ORDER BY dla.display_line_number
