-
-

Requisition Detail

PURCHASING

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