APPS.POS_ACK_PO dependencies on PO_VENDORS

Line 166: from po_vendors pov,po_headers_all poh

162: -- Get the Vendor Name
163: if l_po_release_id is null then
164: select pov.vendor_name
165: into x_vendor
166: from po_vendors pov,po_headers_all poh
167: where pov.vendor_id = poh.vendor_id
168: and poh.po_header_id=l_po_header_id;
169: else
170: select pov.vendor_name

Line 172: from po_releases_all por,po_headers_all poh,po_vendors pov

168: and poh.po_header_id=l_po_header_id;
169: else
170: select pov.vendor_name
171: into x_vendor
172: from po_releases_all por,po_headers_all poh,po_vendors pov
173: where por.po_release_id = l_po_release_id
174: and por.po_header_id = poh.po_header_id
175: and poh.vendor_id = pov.vendor_id;
176: end if;