DBA Data[Home] [Help]

APPS.PO_CUSTOMERS_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

   SELECT pola.customer_id,
	  pola.address_id,
	  pola.site_use_id
   INTO   x_customer_id,
	  x_address_id,
	  x_site_use_id
   FROM   po_location_associations_all pola,
          org_organization_definitions org
   WHERE  pola.location_id = x_deliver_to_location_id
   AND    org.organization_id= x_source_org_id  -- bug 5028505
   AND    org.operating_unit= pola.org_id;      -- bug 5028505