Message Code: DBG_21263
Message: Invalid lookup override SELECT DISTINCT PO_HEADERS_ALL.SEGMENT1 AS PO_NUMBER,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID AS INVOICE_ID ,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER AS INVOICE_LINE_NUMBER,
HR_LOCATIONS_ALL.ATTRIBUTE4 AS BUSINESS_UNIT /* THIS IS TO EXPOSE THE TASK LEVEL COMMITMENT'S AND ACTUAL'S BUSINESS UNIT */
FROM PO_DISTRIBUTIONS_ALL,
AP_INVOICE_DISTRIBUTIONS_ALL, PO_HEADERS_ALL
left outer join
HR_LOCATIONS_ALL on PO_HEADERS_ALL.SHIP_TO_LOCATION_ID = HR_LOCATIONS_ALL.LOCATION_ID
where AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
and PO_DISTRIBUTIONS_ALL.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID--
Message Code: DBG_21263
Message: Invalid lookup override SELECT DISTINCT PO_HEADERS_ALL.SEGMENT1 AS PO_NUMBER,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID AS INVOICE_ID ,
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER AS INVOICE_LINE_NUMBER,
HR_LOCATIONS_ALL.ATTRIBUTE4 AS BUSINESS_UNIT /* THIS IS TO EXPOSE THE TASK LEVEL COMMITMENT'S AND ACTUAL'S BUSINESS UNIT */
FROM PO_DISTRIBUTIONS_ALL
inner join
AP_INVOICE_DISTRIBUTIONS_ALL
on AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
inner join PO_HEADERS_ALL
on PO_DISTRIBUTIONS_ALL.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID
left outer join
HR_LOCATIONS_ALL on PO_HEADERS_ALL.SHIP_TO_LOCATION_ID = HR_LOCATIONS_ALL.LOCATION_ID
How can i implement left outer join in Lookup override Query?