Query to retrieve Trade Operation and corresponding PO details

Summary:

Content (required):

Hi,

There is a requirement to create a report that displays the following columns;

• Trade Operation number
• Trade Operation Name
• Created By User
• Last Updated by User
• PO Number

We have built the below query;

SELECT 

cto.TRADE_OPERATION_ID,

cto.STATUS_CODE,

cto.CREATED_BY,

cto.LAST_UPDATED_BY,

cto.TRADE_OPERATION_NUMBER,

ctoc.PO_HEADER_ID,

poi.SEGMENT1

FROM cml_trade_operations cto,

CML_TRADE_OPERATION_CHARGES ctoc,

PO_HEADERS_INTERFACE poi

WHERE cto.TRADE_OPERATION_ID = ctoc.TRADE_OPERATION_ID

AND ctoc.PO_HEADER_ID = poi.PO_HEADER_ID

However, 'CML_TRADE_OPERATION_CHARGES' does not capture PO Header ID if the PO is Non-Service.