Use this query in SQL Developer

The Two Ewes Driver enables you to run this query directly against your Oracle Fusion Applications, right from SQL Developer. Give it a try right now with a no obligation trial period.

Contributed By

Two Ewes

Send Email

Purchase Order Detail

PURCHASING

Obtain Purchase Order Details Details


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    ,
        PRHA.REQUISITION_NUMBER     ,
        PRHA.DOCUMENT_STATUS        ,
        PRHA.PROCESS_STATUS         ,
        PRLA.REQUISITION_LINE_ID    ,
        pha.segment1 po_number      ,
        pha.DOCUMENT_STATUS         ,
        pla.line_num po_line_number ,
        pla.LINE_STATUS             ,
        pla.item_description        ,
        plla.shipment_num           ,
        plla.QUANTITY               ,
        plla.QUANTITY_RECEIVED      ,
        plla.QUANTITY_ACCEPTED      ,
        plla.QUANTITY_REJECTED      ,
        plla.QUANTITY_BILLED        ,
        plla.QUANTITY_CANCELLED
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               ,
        fusion.po_headers_all pha              ,
        fusion.po_lines_all pla                ,
        fusion.po_line_locations_all plla
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
        AND pha.po_header_id              = prla.po_header_id
        AND pla.po_line_id                = prla.po_line_id
        AND plla.po_line_id (+)           = pla.po_line_id
ORDER BY dla.display_line_number