Total Pageviews

November 5, 2015

11/05/2015 01:02:00 AM

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'