APPS.FTE_UTIL_PKG SQL Statements

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

Line: 142

    SELECT hz.PARTY_ID  INTO l_carrier_id
      FROM   HZ_PARTIES hz, WSH_CARRIERS ca
      WHERE  hz.party_name = p_carrier_name
        AND    hz.party_id   = ca.carrier_id;

Line: 173

    SELECT hz.PARTY_name
    INTO l_carrier_name
    FROM HZ_PARTIES hz
    WHERE hz.party_id = p_carrier_id;

Line: 212

      SELECT lookup_code  INTO l_code
        FROM   fnd_lookup_values_vl
        WHERE  lookup_type = p_lookup_type
          AND    lookup_code = p_value;

Line: 221

          SELECT lookup_code  INTO l_code
            FROM   fnd_lookup_values_vl
            WHERE  lookup_type = p_lookup_type
              AND    meaning like p_value;

Line: 256

      SELECT p_uom_class--||'_uom_class'
	INTO l_uom_class
        FROM wsh_shipping_parameters
        WHERE rownum < 2;

Line: 290

        SELECT uom_code  INTO l_code
          FROM   mtl_units_of_measure
          WHERE  uom_code  = p_uom;

Line: 298

            SELECT uom_code INTO l_code
              FROM   mtl_units_of_measure
              WHERE  unit_of_measure = p_uom;

Line: 313

          SELECT  uom_code  INTO l_code
            FROM  mtl_units_of_measure
            WHERE uom_code  = p_uom
	      AND uom_class = l_shipping_uom_class;

Line: 322

              SELECT  uom_code INTO l_code
                FROM  mtl_units_of_measure
                WHERE unit_of_measure = p_uom
		  AND uom_class = l_shipping_uom_class;

Line: 405

      SELECT veh.vehicle_type_id
      INTO  l_veh_id
      FROM  mtl_system_items_kfv mtl, fte_vehicle_types veh
      WHERE mtl.concatenated_segments = p_vehicle_type
      AND   mtl.inventory_item_id = veh.inventory_item_id
      AND   mtl.vehicle_item_flag = 'Y'
      AND   rownum = 1;

Line: 416

          SELECT veh.vehicle_type_id
          INTO  l_veh_id
          FROM  mtl_system_items_kfv mtl, fte_vehicle_types veh
          WHERE to_char(veh.vehicle_type_id) = p_vehicle_type
          AND   mtl.inventory_item_id = veh.inventory_item_id
          AND   mtl.vehicle_item_flag = 'Y'
          AND   rownum = 1;

Line: 464

      SELECT concatenated_segment_delimiter
        INTO l_delimiter
        FROM fnd_id_flex_structures
       WHERE id_flex_code = 'MCAT'
         AND id_flex_structure_code='WSH_COMMODITY_CODE'
         AND application_id = 401;

Line: 498

      SELECT category_id
        INTO l_id
        FROM mtl_categories_kfv c, mtl_category_sets s
       WHERE s.structure_id = c.structure_id
         AND s.category_set_name = 'WSH_COMMODITY_CODE'
         AND c.concatenated_segments like l_value||'%'
	 AND rownum = 1;

Line: 543

  SELECT c.category_id, c.concatenated_segments, c.segment1, c.segment2, c.segment3
  FROM   mtl_categories_kfv c, mtl_category_sets s
  WHERE  s.structure_id       = c.structure_id
  AND    s.category_set_name  = 'WSH_COMMODITY_CODE';

Line: 549

  SELECT concatenated_segment_delimiter
  FROM   fnd_id_flex_structures
  WHERE  id_flex_code           = 'MCAT'
  AND    id_flex_structure_code ='WSH_COMMODITY_CODE'
  AND    application_id         = 401;

Line: 692

      SELECT currency_code INTO l_currency
      FROM   fnd_currencies
      WHERE  currency_code = p_currency
	AND  enabled_flag = 'Y'
    	AND  currency_flag = 'Y'
    	AND  nvl(start_date_active, sysdate) <= sysdate
	AND  nvl(end_date_active, sysdate) >= sysdate
        AND  rownum = 1;

Line: 705

          SELECT currency_code INTO l_currency
          FROM   fnd_currencies_vl
          WHERE  name = p_currency
	    AND  enabled_flag = 'Y'
	    AND  currency_flag = 'Y'
	    AND  nvl(start_date_active, sysdate) <= sysdate
	    AND  nvl(end_date_active, sysdate) >= sysdate
            AND  rownum = 1;