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 1220: -- 2. po_vendor_contacts (see Bug 4597324)

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

Line 1262: po_vendor_contacts pvc

1258: l_fax_area,
1259: l_faxnum
1260: from po_headers_all poh,
1261: po_vendor_sites_all pvs,
1262: po_vendor_contacts pvc
1263: where poh.vendor_site_id = pvs.vendor_site_id and
1264: poh.vendor_contact_id = pvc.vendor_contact_id (+) and
1265: poh.po_header_id = p_document_id and
1266: pvs.vendor_site_id = NVL(pvc.vendor_site_id, pvs.vendor_site_id);

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

1280:
1281:
1282: elsif (p_document_type = 'RELEASE') then
1283: begin
1284: -- We default email/fax from po_vendor_contacts (see Bug
1285: -- 4597324), then po_vendor_sites_all.
1286:
1287: -- Bug 6625807 / 6526600
1288: -- Added pvs.vendor_site_id = NVL(pvc.vendor_site_id,

Line 1306: po_vendor_contacts pvc,

1302: l_fax_area,
1303: l_faxnum
1304: from po_headers_all poh,
1305: po_vendor_sites_all pvs,
1306: po_vendor_contacts pvc,
1307: po_releases por
1308: where poh.vendor_site_id = pvs.vendor_site_id and
1309: poh.vendor_contact_id = pvc.vendor_contact_id (+) and
1310: poh.po_header_id = por.po_header_id and