APPS.WIP_WF_UPDATE_DATE dependencies on PO_VENDOR_SITES_ALL
Line 89: from po_vendors pv, po_vendor_sites_all pvs, po_headers_all ph
85: /* get vendor data */
86: begin
87: select pv.vendor_name, pvs.vendor_site_code
88: into x_subcontractor_name, x_subcontractor_site 89: from po_vendors pv, po_vendor_sites_all pvs, po_headers_all ph 90: where ph.po_header_id = x_po_header_id
91: and pv.vendor_id = ph.vendor_id
92: and pvs.vendor_site_id = ph.vendor_site_id
93: and pvs.org_id = ph.org_id;