APPS.PO_VENDOR_SITES_SV dependencies on PO_VENDOR_CONTACTS

Line 550: po_vendor_contacts_sv.get_vendor_contact(X_vendor_site_id,

546: end if;
547:
548: /* Default the Vendor Contact if possible */
549:
550: po_vendor_contacts_sv.get_vendor_contact(X_vendor_site_id,
551: X_vendor_contact_id,
552: X_vendor_contact_name);
553:
554: exception

Line 1217: -- 2. po_vendor_contacts (see Bug 4597324)

1213: -- PO (i.e. for POs created/modified in HTML), use that instead
1214: -- of the Supplier Site defaults. Also, we default email/fax
1215: -- from 3 places, in order of priority:
1216: -- 1. po_headers_all
1217: -- 2. po_vendor_contacts (see Bug 4597324)
1218: -- 3. po_vendor_sites_all
1219:
1220: -- Bug 6625807 / 6526600
1221: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,

Line 1242: po_vendor_contacts pvc

1238: l_fax_area,
1239: l_faxnum
1240: from po_headers_all poh,
1241: po_vendor_sites_all pvs,
1242: po_vendor_contacts pvc
1243: where poh.vendor_site_id = pvs.vendor_site_id and
1244: poh.vendor_contact_id = pvc.vendor_contact_id (+) and
1245: poh.po_header_id = p_document_id and
1246: pvs.vendor_site_id = NVL(pvc.vendor_site_id, pvs.vendor_site_id);

Line 1264: -- We default email/fax from po_vendor_contacts (see Bug

1260:
1261:
1262: elsif (p_document_type = 'RELEASE') then
1263: begin
1264: -- We default email/fax from po_vendor_contacts (see Bug
1265: -- 4597324), then po_vendor_sites_all.
1266:
1267: -- Bug 6625807 / 6526600
1268: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,

Line 1282: po_vendor_contacts pvc,

1278: l_fax_area,
1279: l_faxnum
1280: from po_headers_all poh,
1281: po_vendor_sites_all pvs,
1282: po_vendor_contacts pvc,
1283: po_releases por
1284: where poh.vendor_site_id = pvs.vendor_site_id and
1285: poh.vendor_contact_id = pvc.vendor_contact_id (+) and
1286: poh.po_header_id = por.po_header_id and