SCM8

 SQL For  BILL TO  and SHIP TO information on Order Line in Oracle Cloud Fusion R13

SELECT  dha.Source_order_number   ,

        dha.order_number          ,

        dha.submitted_Flag        ,

        dfla.SHIP_TO_PARTY_ID     ,

        dfla.SHIP_TO_PARTY_SITE_ID,

        dfla.BILL_TO_CUSTOMER_ID  ,

        dfla.BILL_TO_SITE_USE_ID

FROM    Fusion.DOO_headers_all dha,

        Fusion.DOO_fulfill_lines_all dfla

WHERE   dha.header_id               = dfla.header_id

        AND dha.source_order_number = '&ENTER SOURCE_ORDER_NUMBER'