DBA Data[Home] [Help]

APPS.PO_VENDORS_PVT dependencies on PO_HEADERS

Line 242: from po_headers_all

238: select DECODE(p_external_contact_id, null, vendor_contact_id, p_external_contact_id) vendor_contact_id
239: ,vendor_site_id, vendor_id, to_char(revision_num)
240: into l_vendor_contact_id
241: ,l_vendor_site_id, l_vendor_id, l_temp
242: from po_headers_all
243: where po_header_id = to_number(p_document_id);
244:
245: elsif (p_document_type = 'RELEASE') THEN
246: l_progress := '030';

Line 254: from po_releases por, po_headers poh

250: , to_char(por.revision_num)
251: into l_vendor_contact_id
252: ,l_vendor_site_id, l_vendor_id
253: , l_temp
254: from po_releases por, po_headers poh
255: where por.po_release_id = to_number(p_document_id)
256: and por.po_header_id = poh.po_header_id;
257:
258: elsif (p_document_type in ('RS')) then -- Bug 3197483