APPS.FTE_FREIGHT_PRICING_UTIL SQL Statements

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

Line: 252

            SELECT 'prc_'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||fte_prc_debug_s.nextval|| '.dbg'
            INTO   g_utl_file_name
            FROM   dual;

Line: 298

      SELECT flv.meaning
      FROM   fnd_lookup_values flv, fnd_lookup_types flt
      WHERE  flv.lookup_type = flt.lookup_type
      AND    flv.lookup_code = p_lookup_code
      AND    flt.lookup_type = p_lookup_type
      AND    flv.language   = USERENV('LANG')
      AND    nvl(flv.start_date_active,sysdate)<=sysdate
      AND    nvl(flv.end_date_active,sysdate)>=sysdate
      AND    flv.enabled_flag = 'Y';

Line: 481

	SELECT name
	FROM wsh_trips
	WHERE trip_id = c_trip_id;

Line: 502

	SELECT lane_number
	FROM fte_lanes
	WHERE lane_id = c_lane_id;

Line: 524

	SELECT hz.party_name
	FROM 	hz_parties hz,
		wsh_carriers wc
	WHERE hz.party_id = wc.carrier_id
	 AND	wc.carrier_id = c_carrier_id;

Line: 547

	SELECT name
	FROM qp_list_headers
	WHERE list_header_id = c_list_id;

Line: 567

	SELECT name
	FROM wsh_new_deliveries
	WHERE delivery_id = c_id;