We are tried to extract the RFQ Summary report. However, when we try to join the po_headers_all pha and PON_AUCTION_HEADERS_ALL paha1 tables using the condition PAHA1.ATTRIBUTE2 = PHA.SEGMENT1, we are not getting the suppliers' information. Can someone please provide some insights on this issue?
where do we need to join the po number and auction table?
please look at my joins and tables for RFQ Summary report
FROM PON_AUCTION_HEADERS_V PAHA,
PON_AUCTION_ITEM_PRICES_ALL PAIP,
PON_AUCTION_HEADERS_ALL PAHA1,
FND_LOOKUP_VALUES FLV,
POZ_SUPPLIERS_V PSV,
POZ_SUPPLIER_SITES_ALL_M PSSM,
egp_system_items_b esb,
AP_TERMS_VL ATL,
EGP_CATEGORIES_VL V,
INV_UNITS_OF_MEASURE_ALL_VL IUM,
--PER_PERSON_NAMES_F_V ppnf,
PO_HEADERS_ALL PHA
WHERE PAHA.AUCTION_HEADER_ID=PAIP.AUCTION_HEADER_ID
AND PAIP.AUCTION_HEADER_ID=PAHA1.AUCTION_HEADER_ID
and FLV.LOOKUP_TYPE='PON_AUCTION_STATUS'
AND FLV.LOOKUP_CODE = pon_auction_pkg.GET_NEGOTIATION_STATUS (PAHA1.AUCTION_HEADER_ID)
AND USERENV ('LANG') = FLV.LANGUAGE
AND PAIP.CATEGORY_ID = V.CATEGORY_ID
AND ESB.PRIMARY_UOM_CODE = IUM.UOM_CODE
and esb.inventory_item_id(+) =PAIP.item_id
AND PAHA1.ATTRIBUTE2 = PHA.SEGMENT1(+)
AND PHA.VENDOR_ID = PSV.VENDOR_ID(+)
AND PHA.VENDOR_SITE_ID = PSSM.VENDOR_SITE_ID(+)
AND PHA.TERMS_ID = ATL.TERM_ID(+)
AND PAHA.DOCUMENT_NUMBER IN()