Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RFQ_SUMMARY_REPORT_ISSUE

Satheesh GuthaMar 27 2024

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()

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Mar 27 2024
0 comments
556 views