DBA Data[Home] [Help]

APPS.CHV_LOAD_ORDERS dependencies on PO_VENDOR_SITES

Line 345: from po_vendor_sites_all pvsa,

341: where mrp.organization_id = x_organization_id
342: and mrp.source_vendor_id = x_vendor_id
343: and x_vendor_site_id =
344: (select distinct pvs.vendor_site_id
345: from po_vendor_sites_all pvsa,
346: po_vendor_sites pvs
347: where pvsa.vendor_site_id = mrp.source_vendor_site_id and
348: pvsa.vendor_id = x_vendor_id and
349: pvs.vendor_site_code = pvsa.vendor_site_code and

Line 346: po_vendor_sites pvs

342: and mrp.source_vendor_id = x_vendor_id
343: and x_vendor_site_id =
344: (select distinct pvs.vendor_site_id
345: from po_vendor_sites_all pvsa,
346: po_vendor_sites pvs
347: where pvsa.vendor_site_id = mrp.source_vendor_site_id and
348: pvsa.vendor_id = x_vendor_id and
349: pvs.vendor_site_code = pvsa.vendor_site_code and
350: pvs.vendor_id = x_vendor_id)

Line 474: po_vendor_sites pvs

470: from po_requisition_headers prh,
471: po_requisition_lines prl,
472: mtl_supply ms,
473: po_vendors pov,
474: po_vendor_sites pvs
475: where ms.to_organization_id = x_organization_id
476: and ms.supply_type_code = 'REQ'
477: and ms.req_header_id = prh.requisition_header_id
478: and ms.req_line_id = prl.requisition_line_id