Complex(Advance Join) In the Information design tool

[Former Member]

Hi Experts,

I need to implement the join like below. When i added AND condition(Which is in BOLD below) manually,  I am seeing " No table found" from the tables table Drop down. Please see screen picture. Does it make a Cross Join when i use it in the reporting? Please advise with your thoughts.

FROM PO_HEADERS_ALL poh

inner join PO_LINES_ALL pol

    on poh.po_header_id = pol.po_header_id

inner join PO_DISTRIBUTIONS_ALL pod

    on pol.po_line_id = pod.po_line_id

inner join PO_LINE_LOCATIONS_ALL poll

    on poll.line_location_id   = pod.line_location_id

inner join mtl_system_items_b msib   

    on pol.item_id = msib.inventory_item_id

    AND poll.SHIP_TO_ORGANIZATION_ID = msib.organization_id

Regards,

Sree

[former_member4998]

Hi..

FROM PO_HEADERS_ALL poh

inner join PO_LINES_ALL pol

    on poh.po_header_id = pol.po_header_id

inner join PO_DISTRIBUTIONS_ALL pod

    on pol.po_line_id = pod.po_line_id

inner join PO_LINE_LOCATIONS_ALL poll

    on poll.line_location_id   = pod.line_location_id

inner join mtl_system_items_b msib  

    on pol.item_id = msib.inventory_item_id

the above joins will work fine….but if include below join also loop will form and you won’t get correct results.

    AND poll.SHIP_TO_ORGANIZATION_ID = msib.organization_id

So better you can alias the MSIB or POLL table as per your requirements. And check the data getting correct or n