Greetings!!
Recently I worked on sourcing module for one of my client. In this process I created report.
which is integration of Oracle Sourcing and Oracle Purchasing
Just thought of sharing the code.
I will give more inputs on Sourcing in next blog posting..
SELECT paha.award_status,
pa.acceptance_type,
pbh.contract_type,
pha.segment1,
ap.vendor_name,
ap.vendor_id,
hp.address1,
hp.city,
hp.postal_code,
hp.state,
hp.county,
hp.country,
pha.org_id,
php.TRADING_PARTNER_NAME,
php.TRADING_PARTNER_CONTACT_NAME,
--fu.user_name.
fu.EMAIL_ADDRESS,
PAIPA.ITEM_description
FROM pon_bid_headers pbh,
pon_auction_headers_all paha,
pon_acceptances pa,
po_headers_all pha,
pa_projects_all ppa,
ap_suppliers ap,
hz_parties hp,
pon_bidding_parties php,
ap_supplier_sites_all assa,
ap_supplier_contacts asca,
fnd_user FU,
pon_auction_item_prices_all paipa
WHERE pbh.auction_header_id(+) = paha.auction_header_id
AND php.auction_header_id = paha.auction_header_id
AND pbh.auction_header_id = php.auction_header_id
AND pa.auction_header_id = php.auction_header_id
AND pa.auction_header_id = php.auction_header_id
AND PAIPa.auction_header_id = php.auction_header_id
AND ap.vendor_id = pbh.vendor_id
AND ap.vendor_id = assa.vendor_id
AND assa.vendor_site_id = asca.vendor_site_id
AND assa.org_id = 204
AND fu.user_id = paha.buyer_id
AND pbh.po_header_id = pha.po_header_id
AND paha.project_id = ppa.project_id(+)
AND ap.party_id = hp.party_id
AND paha.auction_header_id = 78
AND pa.acceptance_type = 'AWARDED'
