APPS.CZ_IB_TSO_GRP SQL Statements

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

Line: 158

     SELECT config_hdr_id,config_rev_nbr,NVL(returned_flag, '0'), NVL(tangible_item_flag,'0')
       INTO l_config_hdr_id,l_config_rev_nbr,l_returned_flag, l_tangible_item_flag
       FROM CZ_CONFIG_ITEMS
      WHERE  instance_hdr_id=p_instance_hdr_id AND
             instance_rev_nbr=p_instance_rev_nbr AND
             config_item_id=p_returned_config_item_id AND
             deleted_flag='0';

Line: 223

       SELECT NVL(returned_flag, '0') INTO l_locked_item_returned_flag FROM CZ_CONFIG_ITEMS
       WHERE  instance_hdr_id=p_instance_hdr_id AND
                       instance_rev_nbr=p_locked_instance_rev_nbr AND
                       config_item_id=p_returned_config_item_id AND
                       deleted_flag='0';

Line: 261

      UPDATE CZ_CONFIG_ITEMS
         SET returned_flag = '1'
       WHERE instance_hdr_id=p_instance_hdr_id AND
             instance_rev_nbr=p_instance_rev_nbr AND
             config_item_id=p_returned_config_item_id AND
             deleted_flag='0';

Line: 276

      UPDATE CZ_CONFIG_ITEMS
         SET returned_flag = '1'
       WHERE instance_hdr_id=p_instance_hdr_id AND
             instance_rev_nbr= p_locked_instance_rev_nbr AND
             config_item_id=p_returned_config_item_id AND
             deleted_flag='0';

Line: 357

     UPDATE CZ_CONFIG_ITEMS
        SET returned_flag = l_returned_flag
      WHERE instance_hdr_id=p_instance_hdr_id AND
            instance_rev_nbr= p_instance_rev_nbr AND
            config_item_id=p_returned_config_item_id AND
            NVL(returned_flag, '0') <> l_returned_flag;

Line: 364

     UPDATE CZ_CONFIG_ITEMS
        SET returned_flag = l_locked_item_returned_flag
      WHERE instance_hdr_id=p_instance_hdr_id AND
            instance_rev_nbr= p_locked_instance_rev_nbr AND
            config_item_id=p_returned_config_item_id AND
            NVL(returned_flag, '0') <> l_locked_item_returned_flag;

Line: 379

     SELECT config_status INTO l_config_status FROM CZ_CONFIG_HDRS
     WHERE config_hdr_id=l_config_model_tbl(1).config_hdr_id AND
           config_rev_nbr=l_config_model_tbl(1).config_rev_nbr;

Line: 388

         SELECT 'F' INTO x_validation_status FROM dual
         WHERE EXISTS(SELECT NULL FROM CZ_CONFIG_MESSAGES
                       WHERE config_hdr_id=l_config_model_tbl(1).config_hdr_id AND
                             config_rev_nbr=l_config_model_tbl(1).config_rev_nbr);