Show Values in the Sourcing Actions Drop down – Oracle Apps

In Sourcing Module we usually need to customize the page based on the Customer Requirement so I felt that the below code snippet will be useful to show the Values.

As a first step the Root Controller Class file has to be Extended

  public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
    OAApplicationModule rootam=null;
    rootam=(OAApplicationModule)pageContext.getRootApplicationModule();     
    OAViewObject actionListVO =null;
    actionListVO = (OAViewObject)rootam.findViewObject("ActionListVO");
      
    AuctionHeadersAllVOImpl auctionVO = (AuctionHeadersAllVOImpl)rootam.findViewObject("AuctionHeadersAllVO");
    auctionVO.reset();
    if (auctionVO.hasNext()) {
        AuctionHeadersAllVORowImpl auctionRow = (AuctionHeadersAllVORowImpl)auctionVO.next();
        Number auctionHeaderId = auctionRow.getAuctionHeaderId();
        pageContext.writeDiagnostics(this, "Inside XXAttachCO PR AuctionId: "+auctionHeaderId, 4);
      }       
    
      pageContext.writeDiagnostics(this, "Inside XXAttachCO PR Before iterating the Action Code and Action Meaning ", 4);
      if (actionListVO != null) {
             int actionListVORowCount = actionListVO.getRowCount();
             int counter =0;
             if (actionListVORowCount > 0) {
               actionListVO.setRangeSize(actionListVORowCount);
               Row[] actionListVORows = actionListVO.getAllRowsInRange();
               for (int i = 0; i < actionListVORows.length; i++) {
                 Row actionListVORow = actionListVORows[i];
                 String actionCode = (String)actionListVORow.getAttribute("Code");
                 String actioMeaning = (String)actionListVORow.getAttribute("Meaning");
                 pageContext.writeDiagnostics(this, "Inside XXAttachCO PR getting actionCode= " + actionCode, 4);
                 pageContext.writeDiagnostics(this, "Inside XXAttachCO PR getting actioMeaning= " + actioMeaning, 4);
             } 
           } 
      }
  }

Query/Link Between Oracle Apps Sourcing and Purchase Order(PO)

Below is the Query in for a High Level

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 = pbh.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’;