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 886: -- get the party name from po_vendors using party_id join.

882: FROM hr_all_organization_units
883: WHERE organization_id = party_rec.party_id;
884:
885: -- b. Else If the party_role_code==SUPPLIER_ORG
886: -- get the party name from po_vendors using party_id join.
887: ELSIF (party_rec.party_role_code = 'SUPPLIER_ORG')
888: THEN
889: SELECT vendor_name
890: INTO l_party_name

Line 891: FROM po_vendors

887: ELSIF (party_rec.party_role_code = 'SUPPLIER_ORG')
888: THEN
889: SELECT vendor_name
890: INTO l_party_name
891: FROM po_vendors
892: WHERE vendor_id = party_rec.party_id;
893: -- c. Else get the party name from hz_parties using party_id join.
894: ELSE
895: SELECT party_name

Line 1407: ,po_vendors v

1403: -- Get the parties associated with this contract
1404: CURSOR party_csr IS
1405: SELECT v.vendor_name
1406: FROM pon_bid_headers b
1407: ,po_vendors v
1408: WHERE b.auction_header_id = p_auction_header_id
1409: AND b.bid_status IN ('ACTIVE','DISQUALIFIED')
1410: AND b.vendor_id = v.vendor_id;
1411: