APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PO_VENDOR_SITES_ALL

Line 39: PO_VENDOR_SITES_ALL vendor_sites,

35: NULL approved_without_check,
36: NULL Reason
37: FROM PO_HEADERS_MERGE_V hdr,
38: PO_VENDORS vendor,
39: PO_VENDOR_SITES_ALL vendor_sites,
40: PON_BID_HEADERS offer
41: WHERE hdr.po_header_id = p_document_id AND draft_id = -1
42: AND hdr.vendor_id = vendor.vendor_id(+)
43: AND vendor.vendor_id = vendor_sites.vendor_id(+)

Line 58: (SELECT vendor_sites.duns_number FROM PO_VENDOR_SITES_ALL vendor_sites WHERE vendor_sites.vendor_site_id = bh.vendor_site_id AND ROWNUM=1) duns_number,

54: bh.trading_partner_name supplier_name,
55: bh.vendor_site_id vendor_site_id,
56: bh.vendor_site_code vendor_site_code,
57: bh.bid_number,
58: (SELECT vendor_sites.duns_number FROM PO_VENDOR_SITES_ALL vendor_sites WHERE vendor_sites.vendor_site_id = bh.vendor_site_id AND ROWNUM=1) duns_number,
59: NULL tin_number,
60: NULL eligibility_status,
61: NULL received_date,
62: NULL performed_by,

Line 86: (SELECT vendor_sites.duns_number FROM PO_VENDOR_SITES_ALL vendor_sites WHERE vendor_sites.vendor_site_id = suppliers.vendor_site_id AND ROWNUM=1) duns_number,

82: trading_partner_name supplier_name,
83: suppliers.vendor_site_id vendor_site_id,
84: suppliers.vendor_site_code vendor_site_code,
85: NULL bid_number,
86: (SELECT vendor_sites.duns_number FROM PO_VENDOR_SITES_ALL vendor_sites WHERE vendor_sites.vendor_site_id = suppliers.vendor_site_id AND ROWNUM=1) duns_number,
87: NULL tin_number,
88: NULL eligibility_status,
89: NULL received_date,
90: NULL performed_by,

Line 965: FROM po_vendor_eligibility vdr, po_vendor_sites_all site

961: FROM TABLE (XMLSEQUENCE (EXTRACT (l_result_xml,'*//results/results'))) a ;
962:
963: CURSOR c_get_vendor_site_details(p_id VARCHAR2) IS
964: SELECT CITY,COUNTRY,vdr.DUNS_NUMBER,PROVINCE,STATE,ADDRESS_LINE1,ADDRESS_LINE2,ZIP,SUPPLIER_NAME
965: FROM po_vendor_eligibility vdr, po_vendor_sites_all site
966: WHERE id = to_number(p_id)
967: AND vdr.vendor_site_id = site.vendor_site_id;
968:
969: l_fnd_lob_seq NUMBER;