APPS.EGO_DEMO_PUB SQL Statements

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

Line: 85

   SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL
   INTO l_item_squence
   FROM DUAL;

Line: 235

SELECT classification_id
INTO l_class_code_id
FROM eng_change_classifications_vl
WHERE classification_name = l_class_code;

Line: 243

  UPDATE eng_engineering_changes
  SET classification_id = l_class_code_id
  where change_id = pChangeId;

Line: 274

  SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL
  INTO l_item_squence
  FROM DUAL;

Line: 294

      SELECT SUBSTR(CONCATENATED_SEGMENTS, 1, 20) INTO l_style_item_num
      FROM MTL_SYSTEM_ITEMS_KFV
      WHERE INVENTORY_ITEM_ID = l_style_item_id
        AND ROWNUM = 1;