APPS.QP_MASS_MAINTAIN_UTIL SQL Statements

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

Line: 19

      select source_system_code, pte_code
      into   l_saved_source_system_code, l_saved_pte_code
      from   qp_list_headers_b
      where  list_header_id = p_list_header_id;

Line: 64

         select Description
           into l_product_desc
           From Mtl_System_Items_Vl
          Where Inventory_Item_Id = l_Inventory_Item_Id
            And Organization_Id = l_Org_Id;

Line: 72

         Select Description
           Into l_product_desc
           From Mtl_categories_vl
          Where category_id = l_category_id;

Line: 112

        select product_uom_code
        into l_uom_code
        from qp_pricing_attributes
        where list_line_id = p_list_line_id
        and product_attribute_context = p_product_attr_context
        and product_attribute = p_product_attr
        and rownum = 1;

Line: 127

PROCEDURE get_valueset_select(p_context_code IN  VARCHAR2,
                              p_segment_code IN  VARCHAR2,
                              x_select_stmt  OUT NOCOPY VARCHAR2,
                              p_segment_map_col IN VARCHAR2 DEFAULT NULL, -- sfiresto fix
                              p_pte IN VARCHAR2 DEFAULT NULL,  -- Hierarchical Categories
                              p_ss  IN VARCHAR2 DEFAULT NULL)  -- Hierarchical Categories
  is
    v_value_set_id   NUMBER;

Line: 138

    v_select_clause   varchar2(4000);

Line: 145

     /* v_select_clause := 'select INVENTORY_ITEM_ID attribute_id, SEGMENT1 attribute_name, nvl(DESCRIPTION, SEGMENT1) attribute_meaning from MTL_SYSTEM_ITEMS_B where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';*/

Line: 147

       v_select_clause := 'select INVENTORY_ITEM_ID attribute_id,concatenated_segments attribute_name,nvl(DESCRIPTION, concatenated_segments) attribute_meaning from MTL_SYSTEM_ITEMS_B_KFV where ORGANIZATION_ID = QP_UTIL.Get_Item_Validation_Org';

Line: 149

        v_select_clause := v_select_clause||' '||'AND  PURCHASING_ITEM_FLAG = '||'''Y''';

Line: 151

      x_select_stmt := 'Select * from (' || v_select_clause || ') AVVO';

Line: 158

        v_select_clause := 'select cat.CATEGORY_ID attribute_id, cat.CONCATENATED_SEGMENTS attribute_name, nvl(cat_vl.DESCRIPTION, cat.CONCATENATED_SEGMENTS) attribute_meaning ';

Line: 159

        v_select_clause := v_select_clause || 'from mtl_categories_b_kfv cat, mtl_categories_vl cat_vl ';

Line: 160

        v_select_clause := v_select_clause || 'where cat.category_id = cat_vl.category_id and cat.STRUCTURE_ID in ';

Line: 161

        v_select_clause := v_select_clause || '(select structure_id from mtl_category_sets where category_set_id = ( select category_set_id from mtl_default_category_sets where functional_area_id = decode(' || l_appl_id || ',201,2,7)) and rownum < 2) ';

Line: 162

        v_select_clause := v_select_clause || 'order by attribute_name';

Line: 163

        x_select_stmt := 'Select * from (' || v_select_clause || ') AVVO';

Line: 170

    select nvl(USER_VALUESET_ID, SEEDED_VALUESET_ID)
      into v_value_set_id
      from qp_segments_b seg, qp_prc_contexts_b cont, fnd_flex_value_sets vs
     where cont.PRC_CONTEXT_CODE = p_context_code
       and seg.SEGMENT_CODE =  p_segment_code
       and nvl(user_valueset_id, seeded_valueset_id) = vs.flex_value_set_id
       and cont.PRC_CONTEXT_ID = seg.PRC_CONTEXT_ID
       and seg.SEGMENT_MAPPING_COLUMN = nvl(p_segment_map_col, seg.SEGMENT_MAPPING_COLUMN) -- sfiresto fix
       and vs.validation_type <> 'N'; -- sfiresto for bug 5136873, all value set types but 'NONE'

Line: 190

       v_select_clause := 'select ';

Line: 194

         v_select_clause := v_select_clause || 'distinct ';

Line: 197

       v_select_clause := v_select_clause || v_cols || ' from ' || v_table_r.TABLE_NAME;

Line: 200

       v_select_clause := 'select flex_value attribute_id, flex_value_meaning attribute_name, nvl(description, flex_value_meaning) attribute_meaning FROM fnd_flex_values_vl WHERE flex_value_set_id = '|| v_value_set_id;

Line: 206

         v_select_clause := v_select_clause || ' ' || QP_UTIL.merge_fnarea_where_clause(v_table_r.WHERE_CLAUSE, p_pte, p_ss);

Line: 208

         v_select_clause := v_select_clause || ' ' || v_table_r.WHERE_CLAUSE;

Line: 212

    x_select_stmt := 'Select * from (' || v_select_clause || ') AVVO';

Line: 221

      x_select_stmt := null;

Line: 223

      x_select_stmt := null;

Line: 226

  end get_valueset_select;