Informatica LKp issue

2699805

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?

SriniVEERAVALLI

Make sure that the query is correct and fetches some data using toad etc.