SELECT
DISTINCT PAIP.LINE_NUMBER AS LINE_NUM ,
PAHA.ATTRIBUTE1 VPI_PROGRAM_NAME,
PAHA.EXT_ATTRIBUTE1 PLANT_SHIP_TO_LOCATION,
PAHA.ATTRIBUTE3 MAC_TRACK,
PAHA.DOCUMENT_NUMBER AS NEGOTIATION_NUMBER ,
PAHA.AUCTION_TITLE AS NEGOTIATION_TITLE,
PAHA.ATTRIBUTE2 AS HEADER_GBPA_NUMBER,
PAHA.CURRENCY_CODE AS NEGOTIATION_CURRENCY,
PAHA.OPEN_BIDDING_DATE AS RFQ_OPEN_DATE,
PON_AUCTION_PKG.GET_AUCTION_STATUS_DISPLAY (PAHA.AUCTION_HEADER_ID,'Y')AS NEGOTIATION_STATUS,
PAHA.CLOSE_BIDDING_DATE AS RFQ_CLOSE_DATE,
PAIP.QUANTITY AS ESTIMATED_QUANTITY,
PAIP.ITEM_DESCRIPTION AS PART_DESCRIPTION,
PAIP.CURRENT_PRICE,
PAIP.TARGET_PRICE,
PAIP.ATTRIBUTE1 LINE_LEVEL_GBPA_NUMBER_1,
PAIP.ATTRIBUTE2 AS LINE_LEVEL_GBPA_NUMBER_2,
PAIP.ATTRIBUTE3 AS LINE_LEVEL_MACTRACK_PROJECT_1,
PAIP.ATTRIBUTE4 AS LINE_LEVEL_MACTRACK_PROJECT_2,
PROCORGUNIT.NAME AS BUSINESS_UNIT,
BUYERNAME.DISPLAY_NAME AS BUYER,
PSV.PARTY_NAME AS SUPPLIER_NAME,
PSSM.VENDOR_SITE_CODE AS SUPPLIER_SITE,
REGEXP_SUBSTR(V.CATEGORY_CODE,'[^.]+',1,1) AS CATEGORY_CODE1,
REGEXP_SUBSTR(V.CATEGORY_CODE,'[^.]+',1,2)AS CATEGORY_CODE2,
REGEXP_SUBSTR(V.CATEGORY_CODE,'[^.]+',1,3)AS CATEGORY_CODE3,
ATT.NAME AS PAYMENT_TERMS,
IUOM.UNIT_OF_MEASURE AS ITEM_UOM,
ESI.ITEM_NUMBER
FROM
PON_AUCTION_ITEM_PRICES_ALL PAIP,
PON_AUCTION_HEADERS_ALL PAHA,
PON_BID_HEADERS PBH,
PER_PERSON_NAMES_F_V BUYERNAME,
HZ_PARTIES PSV,
POZ_SUPPLIER_SITES_ALL_M PSSM,
HZ_PARTIES POZCONTACTS,
EGP_CATEGORIES_B V,
EGP_SYSTEM_ITEMS_VL ESI,
PO_LINES_ALL PLA,
PO_HEADERS_ALL PHA,
HR_ORGANIZATION_UNITS_F_TL PROCORGUNIT,
AP_TERMS_TL ATT,
INV_UNITS_OF_MEASURE IUOM,
inv_org_parameters IP
WHERE 1=1
AND PAHA.AUCTION_HEADER_ID=PAIP.AUCTION_HEADER_ID
AND PAHA.AUCTION_HEADER_ID=PBH.AUCTION_HEADER_ID
--AND PBH.BEST_BID_NUMBER = PAIP.BEST_BID_NUMBER
AND PAHA.PRC_BU_ID = PROCORGUNIT.ORGANIZATION_ID
AND PAHA.PERSON_ID = BUYERNAME.PERSON_ID
AND PBH.TRADING_PARTNER_ID = PSV.PARTY_ID
AND PBH.VENDOR_SITE_ID = PSSM.VENDOR_SITE_ID(+)
AND PBH.TRADING_PARTNER_CONTACT_ID = POZCONTACTS.PARTY_ID(+)
AND PAIP.CATEGORY_ID = V.CATEGORY_ID
AND V.CATEGORY_ID = PLA.CATEGORY_ID(+)
AND PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PHA.TERMS_ID = ATT.TERM_ID(+)
AND PLA.UOM_CODE = IUOM.UOM_CODE
AND PLA.ITEM_ID =ESI.INVENTORY_ITEM_ID(+)
AND ESI.ORGANIZATION_ID =IP.ORGANIZATION_ID
ORDER BY PAIP.LINE_NUMBER
I need to obtain comprehensive details regarding the RFQ and RFQ Summary Report. While working on the report, I encountered a problem where it produces multiple lines when I add the join for RFQ payment terms. Could someone assist me with this issue?
Could someone please provide the query for this?