DBA Data[Home] [Help]

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;