eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on PO_VENDORS

Line 880: -- get the party name from po_vendors using party_id join.

876: FROM hr_all_organization_units
877: WHERE organization_id = party_rec.party_id;
878:
879: -- b. Else If the party_role_code==SUPPLIER_ORG
880: -- get the party name from po_vendors using party_id join.
881: ELSIF (party_rec.party_role_code = 'SUPPLIER_ORG')
882: THEN
883: SELECT vendor_name
884: INTO l_party_name

Line 885: FROM po_vendors

881: ELSIF (party_rec.party_role_code = 'SUPPLIER_ORG')
882: THEN
883: SELECT vendor_name
884: INTO l_party_name
885: FROM po_vendors
886: WHERE vendor_id = party_rec.party_id;
887: -- c. Else get the party name from hz_parties using party_id join.
888: ELSE
889: SELECT party_name

Line 1395: ,po_vendors v

1391: -- Get the parties associated with this contract
1392: CURSOR party_csr IS
1393: SELECT v.vendor_name
1394: FROM pon_bid_headers b
1395: ,po_vendors v
1396: WHERE b.auction_header_id = p_auction_header_id
1397: AND b.bid_status IN ('ACTIVE','DISQUALIFIED')
1398: AND b.vendor_id = v.vendor_id;
1399: