APPS.FTE_PROCESS_REQUESTS SQL Statements

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

Line: 136

SELECT hcas.cust_account_id
FROM   wsh_locations wl,
       hz_party_sites hps,
       hz_cust_acct_sites_all hcas
WHERE  wl.wsh_location_id = p_location_id
AND    wl.location_source_code = 'HZ'
AND    wl.source_location_id = hps.location_id
AND    hps.party_site_id = hcas.party_site_id;

Line: 146

SELECT distinct hcas.cust_account_id
FROM   hz_cust_site_uses_all hcsu,
       hz_cust_acct_sites_all hcas
WHERE  hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND    hcsu.site_use_id = p_site_id;

Line: 563

  SELECT mrp_atp_schedule_temp_s.nextVal
  FROM   dual;

Line: 567

  SELECT ship_method_meaning
  FROM   wsh_carrier_services
  WHERE  ship_method_code = p_ship_method_code;

Line: 572

  SELECT ship_method_meaning
  FROM   wsh_carrier_services
  WHERE  carrier_id = p_carrier_id AND
         mode_of_transport = p_mode AND
         service_level = p_service;

Line: 579

  SELECT wcs.ship_method_code
  FROM   wsh_org_carrier_services wocs,
         wsh_carrier_services     wcs,
         wsh_carriers             wc
  WHERE  wcs.service_level= p_service AND
         wcs.mode_of_transport= p_mode AND
         wcs.enabled_flag       = 'Y' AND
         wcs.carrier_service_id = wocs.carrier_service_id AND
         wocs.organization_id   = p_org_id AND
         wocs.enabled_flag      = 'Y' AND
         wcs.carrier_id         = wc.carrier_id AND
         nvl(wc.generic_flag, 'N') = 'Y';

Line: 593

  SELECT wcs.ship_method_code
  FROM   wsh_org_carrier_services wocs,
         wsh_carrier_services     wcs,
         wsh_carriers             wc
  WHERE
         wcs.mode_of_transport = p_mode AND
         wcs.enabled_flag       = 'Y' AND
         wcs.carrier_service_id = wocs.carrier_service_id AND
         wocs.organization_id   = p_org_id AND
         wocs.enabled_flag      = 'Y' AND
         wcs.carrier_id         = wc.carrier_id AND
         nvl(wc.generic_flag, 'N') = 'Y';

Line: 607

  SELECT wcs.ship_method_code
  FROM   wsh_org_carrier_services wocs,
         wsh_carrier_services     wcs,
         wsh_carriers             wc
  WHERE  wcs.service_level = p_service AND
         wcs.enabled_flag       = 'Y' AND
         wcs.carrier_service_id = wocs.carrier_service_id AND
         wocs.organization_id   = p_org_id AND
         wocs.enabled_flag      = 'Y' AND
         wcs.carrier_id         = wc.carrier_id AND
         nvl(wc.generic_flag, 'N') = 'Y';

Line: 812

	-- Do carrier selection for each consolidation if consolidated successfully
	-- and action is C or B
	IF (p_source_header_tab.COUNT > 0 AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
	    AND (p_action = 'C' OR p_action = 'B')) THEN

          IF (l_otm_installed = 'N') THEN
	    FORMAT_CS_CALL( p_source_header_tab     => p_source_header_tab,
	 		   p_source_line_tab	    => p_source_line_tab,
			   x_result_tab		    => l_result_tab,
			   x_return_message         => l_return_message,
			   x_return_status          => l_status);

Line: 1031

						-- no carrier selection results at all
                                                x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;