APPS.GMO_DISPENSE_GRP SQL Statements

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

Line: 53

      UPDATE GMO_MATERIAL_DISPENSES
          SET reservation_id = p_new_reservation_id
        WHERE batch_id = p_batch_id
          and inventory_item_id = p_item_id
          and material_detail_id = p_material_detail_id
          and reservation_id = p_old_reservation_id
          and nvl(batch_step_id,1) = nvl(p_batchstep_id,1);

Line: 61

      UPDATE GMO_MATERIAL_UNDISPENSES
	   SET reservation_id = p_new_reservation_id
	 WHERE batch_id = p_batch_id
	   and inventory_item_id = p_item_id
	   and material_detail_id = p_material_detail_id
	   and reservation_id = p_old_reservation_id
          and nvl(batch_step_id,1) = nvl(p_batchstep_id,1);

Line: 163

      select count(*) into l_status_code_exists
      from fnd_lookups
      where lookup_type = 'GMO_DISP_MTL_STATUS'
       and lookup_code <> 'DISPENSD'
       and  lookup_code = p_status_code;

Line: 174

       UPDATE GMO_MATERIAL_DISPENSES
         SET material_status = p_status_code,
             DISPENSE_SOURCE_TRANSACTION_ID = nvl(DISPENSE_SOURCE_TRANSACTION_ID, p_transaction_id)
        WHERE dispense_id = p_dispense_id;

Line: 295

      SELECT COUNT(*) INTO L_COUNT
      FROM MTL_SYSTEM_ITEMS_VL
      WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
      AND   ORGANIZATION_ID = P_ORGANIZATION_ID
      AND RESERVABLE_TYPE = 2;