Obtain Review Requisition interface details, including errors. NOTE: This data may be purged by the requisition import process
SELECT 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 ,
prlia.REQUISITION_HEADER_ID ,
prlia.REQUISITION_LINE_ID ,
prie.MESSAGE_NAME ,
prie.TEXT_LINE ,
prie.COLUMN_NAME ,
prie.COLUMN_VALUE ,
prie.TOKEN_NAME1 ,
prie.TOKEN_VALUE1
FROM fusion.POR_REQ_HEADERS_INTERFACE_ALL prhia ,
fusion.POR_REQ_LINES_INTERFACE_ALL prlia ,
fusion.doo_headers_all dha ,
fusion.doo_fulfill_lines_all dfla ,
fusion.doo_lines_all dla ,
fusion.POR_REQ_IMPORT_ERRORS PRIE
WHERE prhia.REQ_HEADER_INTERFACE_ID = prlia.REQ_HEADER_INTERFACE_ID
AND dha.header_id = dfla.header_id
AND TO_CHAR(dha.header_id) = prhia.INTERFACE_HEADER_KEY
AND TO_CHAR(dfla.fulfill_line_id) = prlia.interface_LINE_KEY (+)
AND prhia.batch_id = prie.import_batch_id (+)
AND prie.INTERFACE_KEY (+) = prlia.interface_LINE_KEY
AND dha.submitted_flag = 'Y'
AND dha.source_order_number IN ('&SOURCE_ORDER_NUMBER')
AND dfla.line_id = dla.line_id
ORDER BY dla.display_line_number
