DBA Data[Home] [Help]

APPS.BOM_SET_CONTEXT SQL Statements

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

Line: 27

      SELECT structure_type_id
      INTO l_structure_type_id
      FROM bom_structure_types_b
      WHERE structure_type_name = nvl(p_struct_type,'All-Structure Types');
Line: 36

        SELECT structure_type_id
          INTO l_pkghier_type_id
        FROM bom_structure_types_b
        WHERE structure_type_name = 'Packaging Hierarchy';
Line: 51

      SELECT fnd_global.resp_appl_id INTO resp_appl_id
        FROM dual;